Excel Date and Highlighting to be Red line

[funkylad20]

If I have some data in a line, and there is a date field, how can I get the line to highlight as red if it is BEFORE today's date? I understand it is Conditional Formatting, but cannot seem to get the formula right? Thanks!

[factor-fiction]

What formula have you written?

[Stamford_Richard]

You need to do this:-
Cell Value is less than =TODAY()

[scotman]

^

That is it. When I used the formula creator I got some " in it. You need to take them out. Or just type it all in by hand.

[funkylad20]

=$D155<TODAY() does not seem to work....if D155 is the date field, and the formatting is set to red pattern...

[chelle7272]

in the conditional formatting box all you need to type is =TODAY() - I've just recehecked and it works for me

[funkylad20]

But it needs to reference it from somewhere? I need the entire line to turn red if it is overdue :o/
I also need to make sure if nothing is entered (i.e. the blank lines below that are waiting to be filled as time goes on) they remain white. The only other option I can think of is entering a second condition to say that =$D155="" and then set the format to white? Not working though :o(

[scotman]

if the date is in cell A1

then

conditional format is

Formula is =$A$1<=today()

Copy that to all required cells using format painter tool

[funkylad20]

OK, and what do you recommend as condition two to say 'if the cell is empty, leave the line white' as at the minute, all of the blank ones are red...?!

[scotman]

sorry

it is

Formula is =$A$1<=today()

[funkylad20]

Looks the same? And, still leaves a red line with a blank entry in cell A1 (using that formula, assuming the date source is in line A1 of course)

[factor-fiction]

It sometimes helps to start with a slightly simpler condition such as if date in one cell = today's date; and then tweak it once you've got it working.

[funkylad20]

I've got the date thing sussed, thanks. If it is before today, it goes red, if it is after today, it remains white. But I cannot suss out how to make sure it remains white (or grey?!) if no data has been entered on the line yet (i.e. an ongoing worksheet which is continually added to)

[funkylad20]

Got it...where D11 is the date entry
=AND($D11<>"",$D11< TODAY())