Forum Discussion

Mahesh_B's avatar
Mahesh_B
Copper Contributor
May 26, 2021
Solved

Formula to Find column1 value in column2 and highlight it

Hi,

I have data like below.

 

 

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

 

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

6 Replies

No RepliesBe the first to reply

Resources