Conditional formatting

[tushar1987]

Hey,

http://www.mrexcel.com/tip054.shtml

I was wondering that the tip you have provided in the above web site can have 3 conditions.

Would it be possible that once the day passes by the color changes to blue. This is because my page gets overcrowded with red background cells.

Thanks

 

[Gerald Higgins]

Hi tushar, welcome to the board.

Yes, this is certainly possible.
Just add a third condition.

If you are replicating the example in the tip, you will need to set up your FIRST condition so that it tests to see if the date is earlier than today, make it blue.
Then, make the second condition the red one, and the third one the green one.