Thanks Vito and Nick...But I don't think I am asking the question
correctly, because I tried all of the ways ya'll suggested, and they
didn't work. What I want to do is for the value in cell E3, I want it
to turn red when E3 is less than D3, AND today's date is past the date
in G3. If all of that is true, then the value in E3 turns red. Hope
that makes it clearer. Thanks again.


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