software

Was trying to enter in Conditional Formatting the following Using the
Formula Is: lt;lt; c/f's perhaps don't take arrays - which In my case are
Holidays during the yeargt;gt;
=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 advanceCheck your first post.

JimMay wrote:
gt;
gt; Was trying to enter in Conditional Formatting the following Using the
gt; Formula Is: lt;lt; c/f's perhaps don't take arrays - which In my case are
gt; Holidays during the yeargt;gt;
gt;
gt; =if(Date($C$2,D$3,$C6)={$S$3,$S$4,$S$5,$S$6,$S$7,$ S$8},True)
gt;
gt; Is there a work-around -- I wish to conditionally format the Dates
gt; listed in S3:S8.
gt;
gt; Thanks, in advance

--

Dave Peterson

As stated earlier

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

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;JimMayquot; gt; wrote in message
news:wD79g.28102$fG3.23983@dukeread09...
gt; Was trying to enter in Conditional Formatting the following Using the
gt; Formula Is: lt;lt; c/f's perhaps don't take arrays - which In my case are
gt; Holidays during the yeargt;gt;
gt;
gt;
gt;
gt; =if(Date($C$2,D$3,$C6)={$S$3,$S$4,$S$5,$S$6,$S$7,$ S$8},True)
gt;
gt;
gt;
gt; Is there a work-around -- I wish to conditionally format the Dates
gt; listed in S3:S8.
gt;
gt;
gt;
gt; Thanks, in advance
gt;
Select cells S3:S8 (S3 is the active cell)
Choose Formatgt;Conditional Formatting
From the first dropdown choose Formula Is
In the formula box, type:
=S3=DATE($C$2,$D$3,$C$6)
Click the Format button, and set your formatting
Click OK, OK.JimMay wrote:
gt; Was trying to enter in Conditional Formatting the following Using the
gt; Formula Is: lt;lt; c/f's perhaps don't take arrays - which In my case are
gt; Holidays during the yeargt;gt;
gt;
gt;
gt;
gt; =if(Date($C$2,D$3,$C6)={$S$3,$S$4,$S$5,$S$6,$S$7,$ S$8},True)
gt;
gt;
gt;
gt; Is there a work-around -- I wish to conditionally format the Dates
gt; listed in S3:S8.
gt;
gt;
gt;
gt; Thanks, in advance
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Uzytkownik quot;JimMayquot; gt; napisal w wiadomosci
news:wD79g.28102$fG3.23983@dukeread09...
gt; Was trying to enter in Conditional Formatting the following Using the
gt; Formula Is: lt;lt; c/f's perhaps don't take arrays - which In my case are
gt; Holidays during the yeargt;gt;
gt;
gt;
gt;
gt; =if(Date($C$2,D$3,$C6)={$S$3,$S$4,$S$5,$S$6,$S$7,$ S$8},True)
gt;
gt;
gt;
gt; Is there a work-around -- I wish to conditionally format the Dates
gt; listed in S3:S8.
gt;
gt;
gt;
gt; Thanks, in advance
gt;
i would put next to your dates any sign (quot;xquot;?)
then in cond formatting in formula i would use vlookup
if it finds x then your conditioning criteria
mcg