↑ Return to Conditional Formatting


Many users of Excel do not know conditional formatting. And yet they use them daily without knowing it.

Many of you change the color of your cell manually with the Font menu. The classical problem when data changes, is the format of your cells doesn’t correspond to the new value of your cells.

So, I will explain with some exemples in this page, how to use conditional formatting.



In the following worksheet, we have the result of five tests and in column H, the average for each student. You want to color in green the highest average and in red the lowest average.

Now, we add the marks for the sixth course, the average has changed, but the format is still the same and doesn’t match the new result.

In this case, you shouldn’t coloured yourself the background of the cells but the conditional formatting.

In the following document, change the value of any cells to see the impact on the format for the column “Average”.



  1. Anonymous

    Hi Laura. Did you ever find a solution to this?

  2. Laura

    Greetings! I followed the instructions from your youtube page in creating an automatic calendar with Excel 2010 in hopes to schedule employees and the project# for sites they will work for a given day ( https://www.youtube.com/watch?v=yY9AbS_ehb0 ).
    However, when I change the month the data entered for a certain date will remain in the same cell. I need to be able to go back and forth between different months so I can track where our techs have been. I followed the directions/formulas in the below link and noticed others have had the same problem but I couldn’t find a solution to the problem…
    How can I set a spreadsheet up to allow changes to a cell for job site project# scheduling/tracking when a new field/selection is made from a form control combo box drop-down list that contains the months of the year?
    I appreciate your time in this matter; thank you!

Leave a Reply

%d bloggers like this: