Formula to Find column value in column2 and highlight it

[Maxgx]

Hi,

I have data like below.

Column 1 column2
11 RTG-2
12 GDR-4
13 LAP-6
14 MAT-8
15 OPR-0
AMG-11
XTR-12
YHE-13
OVT-14
KHK-15
UTH-16
IKL-17

Capture.JPG

I want to find value of column in column 2 . Column 2 will not have exact value, but will have complete value present .
And once I find value I want to highlight the same cell with some color of put that in column 3.

Is there any way to achieve this ?

Thanks,
Mahesh

[alansidman]

Your explanation is vague and not understandable to me. Suggest you read the banner at the top of this page and attach a worksheet with a mocked up solution.