![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formating all cells in an array based on adjacent cells | deejay | Excel | 6 | 12-20-2016 12:00 PM |
![]() |
ijewel | Excel | 1 | 03-16-2016 05:15 AM |
Conditional Formatting based on Value of Another Cell | SteveBump | Excel | 3 | 03-07-2014 09:16 AM |
![]() |
trueimage | Excel Programming | 1 | 10-25-2013 12:08 PM |
![]() |
avanderh | Excel | 11 | 07-28-2011 09:10 AM |