Sure. I dumped hire date data from PeopleSoft Query to excel file. I
performed the steps to reformat the dates from yyyy/mm/dd to
mm/dd/yyyy. highlighted the entire column, clicked on format -
conditional formatting, selected for conditional 1, "formula is"; in
the second field, i entered the formula
=IF(E3:E5286<=DATE(2005,1,4),"yes","no"); clicked the format button,
selected the Pattern tab, chosed the yellow color and clicked OK,
twice. Still nothing. Thanks.