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
 

Simon Lloyd

Administrator
Joined
Apr 2, 2011
Messages
401
Reaction score
0
Points
0
Location
Manchester, England
Excel Version(s)
Excel 2016
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
 
Top