I have a temperature chart that I have set up for this year. When I type in the high temperature for the day, the cell turns to a designated color in my chart (so, for example, when it is between 81-85, the cell will be yellow, when 86-90 it will be pink, and so on).

Now that I am in December, I went to a section below all the temperatures/dates and created a list of cells for the months, and then a formula to figure out the average temperature for each month and for the year.

However, when I apply the same conditional formatting to those cells, they do not all turn to the assigned color - some of them are off. I can only guess that it is because there is a formula applied to that cell instead of just typing in the number.

How do I get the averages (still in column B below line 368) to use the same formatting as the cells above? For a temporary fix, I had to type in the averages manually into cell C next to them.

Hope that makes sense. I am using the temperatures for a crochet project.

Attached Files

2016TempChart.xlsx (56.8 KB, 12 views)