Conditional Format line if date is overdue

Shazz

New member
Joined
May 9, 2012
Messages
15
Reaction score
0
Points
0
Hi All,

I am looking to use Conditional Formatting to highlight a whole row is a date is approaching or overdue from a date in D2, I would lik to highlight in Orange if one day before the date in D2 and Red if date is D2 has been reached or overdue.

Does anyone have any iseas at all please.

Thanks very much.

Shazz
xx
 

Shazz

New member
Joined
May 9, 2012
Messages
15
Reaction score
0
Points
0
Thanks very much, one question.

With using these conditional formatting, any blank cells shows the format i.e red, how can I get it so that if a date is not in the cell it just shows as blank.

Shazz
 

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,779
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
You can add something along the lines of
Code:
=and(B2>0,B2<today())
so that empty cells are omitted
 
Top