Forum Discussion
Mahesh_B
May 26, 2021Copper Contributor
Formula to Find column1 value in column2 and highlight it
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-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