I have attached a ss with two pivots that i need to compare on a daily basis.
The books and isin will change ever day, so the number of rows and columns will change in both pivots (Pivot & Sophis Pivot)
The aim of the comparison is to highlight in green any matching data from Sophis Pivot into Pivot.
I have highlighed green some of the matches and red some of the no matches.
Is it possible to run some code that could run through the pivots and identify the matches highlight green and then identify the non matches and highlight red?
All zeros would be ignored.