J
Johnny1r
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.
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.