Hi All,
I have two pivot tables of data that I would like to compare & contrast by highlighting the cells that are the same between the tables in green and the cells that differ between the tables in red.
I imagine this could be done without VBA, however one conundrum I am running into is that table1 has more information than table2. Thus, not all of the information in the two tables geometrically match up. Nonetheless, the info that does match up is paired by the same primary and secondary keys.
Any recommendations on how I may proceed?
Thank you!
AjKim
Bookmarks