Hello Excel Gurus,
I would appreciate if i could get some tips on a validation exercise:
i have data in 2 rows with few cells having different values. I want to compare the two rows and highlight the cells with differences.
Example: In the data below, cells B1 and B2 with value 45 & 46 would be highlighted since the 2 cells differ in value in 2 rows. Same would apply for C1 and C2.
Image.png
A B C D
1 A345 45 2/7/2012 Name
2 A345 46 1/7/2013 Name
Thank you!!
Bookmarks