ExcelBanter - conditional format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - conditional format (https://www.excelbanter.com/excel-discussion-misc-queries/258258-conditional-format.html)

Yousoft

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

Jacob Skaria

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

All times are GMT +1. The time now is 05:14 AM.