Conditional Formatting Assistance

[JimMay]

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

 

[Dave Peterson]

Check your first post.

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

 

[Peo Sjoblom]

As stated earlier

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Debra Dalgleish]

Select cells S3:S8 (S3 is the active cell)
Choose Format>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.

 

[Gazeta]

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

i would put next to your dates any sign ("x"?)
then in cond formatting in formula i would use vlookup
if it finds x then your conditioning criteria
mcg