Forum Discussion
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...
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
'key' and 'Toy' which are not matching? 'Drawer' will be reference column in both tables.
If not, I can still live with this solution
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
