Just mentioned it as a point of information Bernard.

Data Validation and CF both automatically give that *false* error message
when trying to reference another sheet using the normal syntax.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bernard Liengme" wrote in message
...
Seemed simpler to use helper column
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"RagDyeR" wrote in message
...
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!