conditional format lookup
 

Hello and thanks ahead for your help. What I have is a column on
sheet1 that I enter names ( Column A ). On sheet17 I have a column
with names in (A1:A300). They are username type names so I need them
to be spelled exactly when I enter them on the first sheet. What I need
is for the cell that I type the name into on sheet 1, to change color
so that I know I have spelled it correcly . I need a conditional format
formula to lookup and check the names on sheet 17 and return a true or
false to do this , I think. Thanks ahead for your help.. John
PS I am using Excel 2000 in windows XP Home.

conditional format lookup
 

Update: I have moved the name list to the same sheet as inpute names
(Sheet1) now CA4:CA304 Thanks John

conditional format lookup
 

I used the solution from Conan Kelly for Thread "conditional formatting
from a list" posted a few above this one. By moving list to same page
did the trick. thanks Conan!!!

Johnny1r wrote:

Update: I have moved the name list to the same sheet as inpute names
(Sheet1) now CA4:CA304 Thanks John