Conditonal Format with a date format
 

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

Kevin,

This works for me. Select all the cells and then use this formula

=OR(A1=--"2005-12-25",A1=--"2006-01-01")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kevin" wrote in message
...
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

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