Excel 2007 : Conditional Formatting - Cell value equal to multiple possibilities

[SaulGoodman]

Hello,
I've searched all over google for a way to execute properly my requirement, but had no success.
Basically, I'm trying to create a Bingo game for my employees here.
I have the "Bingo Cards" which are simply 5x5 tables with random numbers in them, and I'd like to implement a conditional formatting rule that would highlight only the cells that contain the drawn numbers every day.
I can easily put a rule that says: If Cell Value is equal to THIS number, then highlight it. Which works fine. But the problem is, we draw 15 numbers every day, so I don't want to have to create a rule for every single number drawn (i.e. 15 rules every morning).
So is there any way to write a rule that says: If Cell Value is equal to NUMBER or NUMBER or NUMBER or NUMBER... etc?

I'd like to avoid macros if possible.

Thank you.

[NBVC]

See your Bingo card is in A1:E6, where A1:E1 are the header cells, then say your list of drawn numbers is located in say column D

Select A2:E6 and apply conditional formatting with Formula =MATCH(A2,$D:$D,0)

and select and apply the colour.

[Richard Buttrey]

Hi,

Yes just name the range containing your 15 numbers as 'numbers' then in the conditional formats of your 5x5 matrix, assuming this starts in A1, use the Conditional format

Please Login or Register  to view this content.

and copy this across and down

HTH

[sweep]

Hi,

With the range of 5x5 cells highlighted, use this conditional formatting rule, and enter the drawn numbers in F1:F15

=OR(A1=$F$1:$F$15)

[SaulGoodman]

See your Bingo card is in A1:E6, where A1:E1 are the header cells, then say your list of drawn numbers is located in say column D

Select A2:E6 and apply conditional formatting with Formula =MATCH(A2,$D:$D,0)

and select and apply the colour.

This worked flawlessly.
Thanks everyone for the quick reply.