| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| Adding worksheet tab names to the first worksheet | Excel Discussion (Misc queries) | |||
| Lookups using worksheet names | Excel Discussion (Misc queries) | |||
| Dynamic Worksheet Names | Links and Linking in Excel | |||
| Defining non worksheet specific names... | Excel Worksheet Functions | |||
Linear Mode
