Highlighting names that come from another worksheet
 

I have a list of names in one worksheet. Is there a way that a name can be
highlighted or have an alert message displayed when one of those names is
typed in a different worksheet so that both worksheets are linked?

Highlighting names that come from another worksheet
 

You may use conditional formating. In order to work make it work with a
different worksheet, you need to put a name to the range you want to monitor
(let's say "Monitor"), and use a formula like this as the condition:
=COUNTIF(Monitor,A1)0

Hope this helps,
Miguel.

"Lukeby" wrote:

I have a list of names in one worksheet. Is there a way that a name can be
highlighted or have an alert message displayed when one of those names is
typed in a different worksheet so that both worksheets are linked?