|(I am assuming that you are familiar with Conditional Formatting. That is what is used to make this work. If not, let us know and we'll explain how to use it.)|
I started with this data:
A B C
4 10/16/2015 2
I then used this formula to Conditionally Format C4, and chose Red as the CF Fill color.
I then changed my system date to 10/20/2015 and forced a calculation. I did not expect C4 to turn Red and it did not.
I then changed my system date to 10/21/2015 and forced a calculation. I expected C4 to turn Red and indeed it did.
If that process does not work for you, I can't say why since I don't have your spreadsheet to test it on. All I can say is that it works for me as I described above.
Note: The TODAY() function is "volatile" which means it will update whenever the sheet calculates any formula. If you just change your system date to test the CF, it won't do anything unless you force a calculation.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03