I tried the conditional formatting once again w/o using the IF, yes-no.
That did work, however, when I copied the format to the other cells,
all of the cells were highlighted including the ones that were not part
of my logic. for ex. I am looking for dates <=1/4/2005, and one of my
dates, 1/18/2005 was highlighted. Should the formatting have skipped
that particular date? Maybe I am not understanding the proper use of
conditional formatting.