Conditional Format line if date is overdue

[Shazz]

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

[Bob Phillips]

Take a look at http://www.xldynamic.com/source/xld.CF.html#due

[Shazz]

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]

You can add something along the lines of

=and(B2>0,B2<today())

so that empty cells are omitted