Conditional formatting based upon array

Lets say there is a calendar that has a1 = 1/1/2006 and a2=a1+1, etc. Now then, lets say you have an array of dates somewhere else and want to change the background color of a1 if its date appears in the array. How can I do that? I have tried if($z$1:$z$10=a1,1,0) and it will only work on the first date, z2's date doesn't change color. Frequency does the same thing.

John

=ISNUMBER(MATCH(A1,$Z$1:$Z$10,0))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"RocketMan" <RocketMan.27wpwq_1147794007.5911@excelforum-nospam.com> wrote
in message news:RocketMan.27wpwq_1147794007.5911@excelforum-nospam.com...
>
> Lets say there is a calendar that has a1 = 1/1/2006 and a2=a1+1, etc.
> Now then, lets say you have an array of dates somewhere else and want
> to change the background color of a1 if its date appears in the array.
> How can I do that? I have tried if($z$1:$z$10=a1,1,0) and it will only
> work on the first date, z2's date doesn't change color. Frequency does
> the same thing.
>
> John
>
>
> --
> RocketMan
> ------------------------------------------------------------------------
> RocketMan's Profile:
http://www.excelforum.com/member.php...o&userid=34491
> View this thread: http://www.excelforum.com/showthread...hreadid=542553
>