Conditional Formatting on Today.

Good Morning,
I am been driven mad by something that should be oh so simple, hope somebody can assist!

I have a spreadsheet which contains a date field in Column "E".
What I want to do is change the colour of the whole row if the date in column "E" is either Today, or a past date.

In the conditional formatting option I have set the following:

Formula Is =INDIRECT("E"&ROW())<=TODAY()

This does work, well to a fashion, as if the cell in column E is blank, it is also taking the formatting rules...

How can I get it to ignore blank cells?????


Thanks!

Hello
after selecting the entire range (say A1 to ZZ5000 or whatever is needed) use the following formula for the CF =AND($E1<=today(),$E1<>"").

The important part of Pecoflyer's solution is the correlation between what is the active cell and the range reference passed in your formula. If you select A1 and then select the rest of your area (whatever it may be, A1:Z1000, whatever), you should see A1 in the name box (directly left of the formula bar). So referencing $E1 would be appropriate. In that instance the column doesn't matter because it's locked in, but the row is relative, so that means it's relative to what the active cell currently is. Something to keep in mind.

Assuming A1 is the active cell (at least row 1 is), you could use a custom formula like this...


Edit: formula is only another alternative, Pecoflyer's would work just as well.

HTH