You're testing for a text string, not a date
You may find it easier to put all your 'stat days' into a range, the set up
the conditional formatting to be along these lines
Formula is =MATCH(A1,date_range,0)0
"Kevin" wrote:
I have a page with colum A1:A365 date formatted I would like all stat days to
turn red Conditional format I am trying to use is,
€¦
=OR(A1:A365=€ťDECEMBER 25, 2004€ť, A1:A365=€śJANUARY 1, 2005€ť) ect ect
I If I type December 25 2004 in column any cell in column A without a date
format, it works. As soon as use a date format in column A1:A365 the
conditional format does not work.
Can anyone help??
Thank you
Kevin
|