Conditional formatting from list on separate sheet

[Guest]

Is there a way to set up conditional formatting where if a name is entered
that is on a list on a seperate workssheet that cell will shade to a selected
color? For example, on worksheet #1 I have a list of 200 names, one which is
Jeff Restad. If I enter that name in worksheet #2, that cell will shade to a
selected color in worksheet #2.

 

[Guest]

Name the list on sheet 1... Select the list of 200 names, then Insert >
Names > Define and provide an appropriate name (say Item_List). You can then
use that defined name in the condition, even though it references another
sheet.
Then use the 'Formula Is' drop-down to establish the condition:
=NOT(ISNA(MATCH(A1,Item_List,0))).

 

[Guest]

Perfect. Thanks.

Name the list on sheet 1... Select the list of 200 names, then Insert >
Names > Define and provide an appropriate name (say Item_List). You can then
use that defined name in the condition, even though it references another
sheet.
Then use the 'Formula Is' drop-down to establish the condition:
=NOT(ISNA(MATCH(A1,Item_List,0))).