Conditional Formating - how to highlight a row if a date has exceeded todays date?

[snoopy1461]

Can someone please help!

Im trying to use conditional formating to highlight rows on a sheet if a date in colunm E is earlier than todays date.

And then if any date is entred into colunm H the row is un-highlighted?

[JBeaucaire]

The CF formula for the first row (row2) would be:

=AND($H2="", $E2>0, $E2<TODAY())

[snoopy1461]

Thanks for that,

But it is bring up a error message, 'Your formula is missing a parenthesis--) or ('

[JBeaucaire]

So I added on at the end... try that.

[snoopy1461]

I did try that before but didnt work and came up with 'The formula you type contains an error'. Is there anything else that i can do?

[JBeaucaire]

Sorry, guess I was asleep at the wheel. CF formulas are TRUE/FALSE constructs, the IF at the beginning is not needed.

=AND($H2="", $E2>0, $E2<TODAY())

[snoopy1461]

Thanks a lot, that's just what i was looking for.

Thanks again for your help