Conditional Format line if date is overdue

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

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

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

You can add something along the lines of so that empty cells are omitted