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 advanceThis 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.

quot;JimMayquot; 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;
gt;
gt;
gt;
gt;

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

Try

=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:3A79g.28101$fG3.3230@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 listed
gt; in S3:S8.
gt;
gt;
gt;
gt; Thanks, in advance
gt;
gt;
gt;
gt;
Maybe something like this:

Select S3:S9, with S3 as the active cell
lt;formatgt;lt;conditional formattinggt;
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, WinXPquot;JimMayquot; 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;
gt;
gt;
gt;
gt;

Thanks very much..
Jim

quot;Peo Sjoblomquot; gt; wrote in message
:

gt; Try
gt;
gt; =ISNUMBER(MATCH(DATE($C$2,D$3,$C6),$S$3:$S$8,0))
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;JimMayquot; gt; wrote in message
gt; news:3A79g.28101$fG3.3230@dukeread09...
gt; gt; Was trying to enter in Conditional Formatting the following Using the
gt; gt; Formula Is: lt;lt; c/f's perhaps don't take arrays - which In my case are
gt; gt; Holidays during the yeargt;gt;
gt; gt;
gt; 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;
gt; gt;
gt; gt; Is there a work-around -- I wish to conditionally format the Dates listed
gt; gt; in S3:S8.
gt; gt;
gt; gt;
gt; gt;
gt; gt; Thanks, in advance
gt; gt;
gt; gt;
gt; gt;
gt; gt;