| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional format
Dear All
I, create conditional format related to one column data range showing the staff ID, I want when I enter the staff ID if it is available in my data range, it will apply my conditional format, so my formula it is working for ID Like 1070, or 1470 But when I inter ID like B1101 It is not working, my formula in conditional format like this =VLOOKUP(A1,$K$2:$K$65,1,FALSE) Please Help Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional format
Try the below instead
=MATCH("*" & A1,$K$2:$K$65,0) -- Jacob "Yousoft" wrote: Dear All I, create conditional format related to one column data range showing the staff ID, I want when I enter the staff ID if it is available in my data range, it will apply my conditional format, so my formula it is working for ID Like 1070, or 1470 But when I inter ID like B1101 It is not working, my formula in conditional format like this =VLOOKUP(A1,$K$2:$K$65,1,FALSE) Please Help Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
| copy conditional format without using format painter | Excel Worksheet Functions | |||
| 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) | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
Linear Mode
