Take a look at http://www.xldynamic.com/source/xld.CF.html#due
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 ofso that empty cells are omittedCode:=and(B2>0,B2<today())
Bookmarks