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