There are times in our spread sheet that we need to format the cells or cell range based on certain conditions. These conditions however pertain to the contents of the cells that you are to format. This is when Conditional Formatting is very useful. For instance, format the cell range G5:G50 if the values in the individual cells is less than 70%. If you are a teacher calculating the students grade in Excel and you want to automatically color the final grade with dark red if they are faling grades, like below… Read More