Re: Conditional Formatting help

Giganews Newsgroups
Subject: Re: Conditional Formatting help
Posted by:  Peo Sjoblom (peo.sjobl…@nw^^excelsolutions.com)
Date: Fri, 12 May 2006

Try

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

"JimMay" <jm…@cox.net> 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

Replies

In response to

Conditional Formatting help posted by JimMay on Fri, 12 May 2006