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.