Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-26-2016, 09:18 AM
kallard kallard is offline Conditional formatting to color cells based on number Windows 10 Conditional formatting to color cells based on number Office 2010 64bit
Novice
Conditional formatting to color cells based on number
 
Join Date: Dec 2016
Posts: 3
kallard is on a distinguished road
Default Conditional formatting to color cells based on number

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
File Type: xlsx 2016TempChart.xlsx (56.8 KB, 12 views)
Reply With Quote
 



Similar Threads
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
Conditional formatting to color cells based on number Sum cell by color that are conditional formatting 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
Conditional formatting to color cells based on number How can I count cells based on their fill color that was set by conditional format trueimage Excel Programming 1 10-25-2013 12:08 PM
Conditional formatting to color cells based on number Conditional color fill based on presence of data avanderh Excel 11 07-28-2011 09:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft