Conditional formatting for dates

Bustah

New member
Joined
Nov 29, 2011
Messages
1
Reaction score
0
Points
0
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
 
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
 
Back
Top