Conditional Formatting help

[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

 

[Guest]

This is a bit longer than the one you have, but it does the trick
=OR(DATE($C$2,D$3,$C6)=$S$3,DATE($C$2,D$3,$C6)=$S$4,DATE($C$2,D$3,$C6)=$S$5,DATE($C$2,D$3,$C6)=$S$6,DATE($C$2,D$3,$C6)=$S$7,DATE($C$2,D$3,$C6)=$S$8)

Hope this helps,
Miguel.

 

[Dave Peterson]

If you want to format the cells in S3:S8, select those cells and with S3 the
activecell:

Format|condional Formatting
Cell value is: Equal to: =DATE($C$2,$D$3,$C$6)

====
If you wanted to format a different cell if that combination of cells (c2,d3,c6)
matched the dates listed in S3:S8, you could use a formula like:

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

If there is no match, this formula evaluates to an error--and CF treats that as
false. If there is a match, then this formula evaluates to a number--and CF
treats that as True.

 

[Peo Sjoblom]

Try

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Guest]

Maybe something like this:

Select S3:S9, with S3 as the active cell
<format><conditional formatting>
Formula is: =(S3=DATE($C$2,$D$3,$C$6))
Click the [format] button and set the formats
Click the [OK] buttons

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

 

[JimMay]

Thanks very much..
Jim

Try

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com