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 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   UT...
Formulas and Functions
  • mtarler's avatar
    mtarler
    May 26, 2021

    Mahesh_B The range in column A included a blank cell at the end and it is a dynamic array formula so you only needed to paste it in the first cell.  If you don't have Excel 365 it won't work.

    I fixed both issues and added the conditional formatting option in the attached.

Mahesh_B's avatar
Mahesh_B
Copper Contributor
May 26, 2021

HiHansVogelaar ,

I tried but its not working.
Can you please help with this?
I have attached file here where I am trying to apply this formula.
Thanks,
Mahesh

HansVogelaar's avatar
HansVogelaar
MVP
May 26, 2021

Mahesh_B 

You posted a workbook with mtarler's formula.

Your data look different from your sample, so you need a slightly different formula.

See the attached version.

Resources