Forum Discussion

Rajiv_Kokitkar's avatar
Rajiv_Kokitkar
Copper Contributor
Mar 18, 2021

Compare two tables & Highlight difference

Hello Experts,   Would be helpful if spare some time & help me with below task ?   Task: To highlight differences (cells) in attached excel by comparing two tables.   Background : We have two t...
Formulas and Functions
Macros and VBA
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Mar 18, 2021

Hi Rajiv_Kokitkar 

You may use conditional formatting with below formula to highlight cells that do not match within two tables:

=IFNA(MATCH(G2,$C$2:$C$8,0),0)

 

 

A sample file is also attached for your reference. Please let me know if it works for you.

 

Thanks

Tauqeer

  • Rajiv_Kokitkar's avatar
    Rajiv_Kokitkar
    Copper Contributor
    Mar 19, 2021
    Thank you Tauqeer . This is helpful. Is it possible to highlight cells from column
    'key' and 'Toy' which are not matching? 'Drawer' will be reference column in both tables.

    If not, I can still live with this solution
    • tauqeeracma's avatar
      tauqeeracma
      Iron Contributor
      Mar 19, 2021

      Hi Rajiv_Kokitkar 

       

      Yes, you can highlight the entire row instead of cells. I have modified below formula in attached file.

       

       

      Hope it works as desired now.

       

      Thanks,

      Tauqeer

Resources