Conditional Formatting by name on seperate worksheet

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

 

[fredg]

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.

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for whatever Office program you
are using. I would suggest you include your Windows and Office version
number in the message.