hi. sorry for the confusion. i have a list of dates in one column. I
highlighted the entire column and used the conditional formatting
"formula is" =IF(E3<=DATE(2005,1,4),"yes","no") then selected the
yellow pattern format. clicked "ok" twice and got nothing. I was
hoping that in that column, some rows would appear highlighted in
yellow based on logic stated above.