View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jazzydwit
 
Posts: n/a
Default conditional formatting

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.