Compare two tables & Highlight difference

New Contributor

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 tables ( Toy_Table & Toy_Drawer) in same sheet ( sheet1). please suggest fastest way to compare both tables & highlight differences in both tables.

 

Additional information :

  • Windows 10
  • MS excel 2016 ( desktop version)

Thanks,

Rajiv

3 Replies

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)

 

tauqeeracma_0-1616094592703.png

 

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

 

Thanks

Tauqeer

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

Hi @Rajiv_Kokitkar 

 

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

 

tauqeeracma_1-1616144667531.png

 

Hope it works as desired now.

 

Thanks,

Tauqeer