Conditional formatting from list on separate sheet
 

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.

Conditional formatting from list on separate sheet
 

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))).

"Supe" wrote:

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.

Conditional formatting from list on separate sheet
 

Perfect. Thanks.


"bpeltzer" wrote:

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))).

"Supe" wrote:

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.