PDA

View Full Version : Conditional formatting for dates



Bustah
2011-11-29, 05:54 PM
I want to be able to cause a cell B3 to turn red if it is a later date than B2. I also want to be able to turn cell B4 red if it is more than 10 working days later than cell B2.

Is there a way of doing this?

Your help really appreciated!

L

Simon Lloyd
2011-11-29, 06:10 PM
in the conditional formatting for B3 you can use "Formula Is" and enter =B3>B2 and in b4 you could do the same but =B4>B2+10