Not sure what you are doing with the formula.
=IF(E3<=DATE(2005,1,4),"yes","no")
But the way I read it - your "Conditional Statement" will return a
"YES" or "NO" answer and is only applicable to cell E3.

I read this as the date is in cell E3, the formula is in another cell,
(i.e. F3).
If you want to "Conditional Format" the "YES and "NO" then select that
column and then select Cell Value in the "Conditional Statement" Box
and enter "equals" then enter "YES" and then select your color or etc.
Save that "Conditional Statement". The do the same again for "NO"
If you want to "Conditional Statement" the Date (i.e. column E) then in
the Cell Value select "less than or equal to" as the condition and then
enter 1005,1,4 in the value section.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=496816