I'm hoping someone can tell me of some way to automate this process:
Say I have a group of 150 numbers in rows like this (each is a different cell):
I would like to be able to enter numbers in another group of cells and, as I enter them, have Excel highlight (or change the cell color) of any matches in the above table. So if I have 15 rows of 10 numbers each, when I enter a '5' in another group of cells, Excel will highlight all of the cells in the 15X10 group that are 5. It is similar to playing bingo. The table above represents the players' cards and the 2nd group of cells represents the draws.
Any ideas?
Thanks in advance!
Bookmarks