Compare 2 data sets and identify differences using Pivot / Conditional formatting (or another method ?)

[Trebor200]

Hi All,

I am looking to compare 2 data sets and identify any differences using colour.
I have demand from a customer and want to compare against an internal demand book.
I have created data set to test this.

I have added 2 data sets into a simple table with one column identifying data source.
I have created a pivot table as shown below and wish to show the differences using colour.
Green is a match and red is an error.

https://www.dropbox.com/s/0igr68wcayfzzx8/Pivot Compare 1.JPG?dl=0

It is possible for a product code to be missing from either data source so i would want to show this as red, as shown for product AC6442400-6.
Data is setup as below.

https://www.dropbox.com/s/ors2xhbpzuoc173/Pivot Compare 2.JPG?dl=0

Excel file is @ the below location.

https://www.dropbox.com/s/rluzeaq70cqfflu/Pivot Compare.xlsx?dl=0

I am open to any other suggestions to complete this task...

Thanks in advance.

 

[oldbrewer]

say your data is just one color in A1 and in D1 representing your demand book

in A1 put =A1<>D1 then if A1=red and D1 = blue A1 will turn red

 

[Trebor200]

sorry im not following?

 

[oldbrewer]

I said pretend the data to compare is just a single cell and I gave you the formula
now if the data is A1 to C3 and say H1 to J3 click on A1, double click format painter and paint the other 8 cells in A1 to C3

 

[Trebor200]

Apologise for the delay, worked a treat. i didn't think of it, i thought is was going to be something complex