Conditional Formatting help
 

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

Conditional Formatting help
 

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.

"JimMay" wrote:

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

Conditional Formatting help
 

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.





JimMay wrote:

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

Conditional Formatting help
 

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

Conditional Formatting help
 

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" wrote:

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

Conditional Formatting help
 

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