how to compare two pivot tables?

[siamandm]

Hello All,
if i have two pivot tables with multiple column, how to compare and find out records in one of the column for specific row has been changed? any quick technique ?

Regards

[HansV]

Do the two pivot tables have exactly the same layout?

[siamandm]

yes they have

Screenshot 2024-02-04 143632.png

attached is a sample data, for two sheets with the same table layout

[HansV]

See the attached workbook.

[siamandm]

thank you for the reply,
what i want is : for example for user01 , i want to check if the numbers in the 4 column next to it is changed or it is same?

[HansV]

Here is an attempt using conditional formatting.

[siamandm]

wow very good thank you very much as usual it works as expected.

[siamandm]

Here is an attempt using conditional formatting.

Dear Hans,
thank you for the sample file, I appreciate if you explain a bit how did you apply the conditional formatting for learning purpose.

Regards

[HansV]

This is the conditional formatting rule on Sheet1:

S2499.png

Clicking Edit Rule... results in

S2500.png

The rule is applied to B2:E8, and the formula in the box shows what it looks like for the top row. Since the row reference in $A2 is relative, Excel will use $A3 in row 3, $A4 in row 4 etc. The column reference is absolute, so the rule will always look at the cell in column A.

The formula looks up the value of the row label on the other sheet and returns the corresponding value from the appropriate column.
The cell is highlighted if that value is different from that of the cell.

[siamandm]

Thank you very much dear Hans, much appreciated.

Regards