Try

=IF($E$3<=DATE(2005,1,4),"yes","no")

You must also click Format, select the Pattern tab, and choose a colour.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"jazzydwit" wrote in message
oups.com...
hi.
now that i have one issue down, another pops up. i need help now with
adding conditional formatting when i enter a formula to highlight
column dates <= to a particular date. what i am doing is highlighting
the entire column that i want to add the conditional format too, then i
enter the formula =IF(E3<=DATE(2005,1,4),"yes","no") add my format and
nothing happens. Please help. thanks.