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.