While your resultant cell is active, Go to Format|Conditional Formatting
and select Is Equal To from middle drop down and paste or type this:
=AND(E3<D3,TODAY()H3)

Then click Format and select formats to apply

Then click Ok.

Before proceeding go back to check the formula in the conditional
format and make sure that there are no quotation marks surrounding it.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=494657