Thanks very much..
Jim

"Peo Sjoblom" wrote in message
:

Try

=ISNUMBER(MATCH(DATE($C$2,D$3,$C6),$S$3:$S$8,0))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"JimMay" wrote in message
news:3A79g.28101$fG3.3230@dukeread09...
Was trying to enter in Conditional Formatting the following Using the
Formula Is: << c/f's perhaps don't take arrays - which In my case are
Holidays during the year



=if(Date($C$2,D$3,$C6)={$S$3,$S$4,$S$5,$S$6,$S$7,$ S$8},True)



Is there a work-around -- I wish to conditionally format the Dates listed
in S3:S8.



Thanks, in advance