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):
Code:
--------------------
3 4 9 15 30 44
1 3 14 23 30 50
2 4 10 18 28 42
--------------------
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!
--
elcapitan
------------------------------------------------------------------------
elcapitan's Profile:
http://www.excelforum.com/member.php...o&userid=31125
View this thread:
http://www.excelforum.com/showthread...hreadid=507926