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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional format lookup
Update: I have moved the name list to the same sheet as inpute names
(Sheet1) now CA4:CA304 Thanks John |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
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) |