Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |