You can assign *names* to references, and then use them from other sheets.


--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bernard Liengme" wrote in message
...
I forgot to explain: you need the count in column E because conditional
formatting does not permit references to other sheets. Pity!
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"pugsly8422" wrote in message
...
I have a main worksheet with a list of everyhing, and then 12 more
worksheets
with smaller lists. What I am doing is typing in something on one of the
12
worksheets and using vlookup to find that on the main worksheet and
transfer
the numbers that correspond. Here is an example:

Main Worksheet
Bob 1 4 3 9 2 7
Shawn 2 3 4 7 5 8

Other Worksheets
I type in "Bob" and the corresponding numbers come up next to Bob's name.


What I would like to do is have the program automatically highlight the
name
on the main worksheet whenever it is typed in on one of the other
worksheets
to make it easier to see who has already been used.

I'm thinking I need to go to the main worksheet and put some type of "IF"
statement in with the names. I would probably use vlookup for that too,
and
just have it search each of the 12 pages, if it finds it, highlight the
name,
and if it doesn't find it, do nothing.

Any help is greatly apprecaited, let me know if there is anymore
information
you may need.

Thanks in advance!