Hi

I'm new here so please excuse me if I'm not very clear.

I am currently working on a worksheet that contains a copy of a pivot
table from another worksheet. Some of the cells which were 0, I
replaced with a sum of values from a different workbook. However, I now
want to color the original cells that once contained 0, blue. Now they
contain different values, and so I wouldn't use conditional format.
Also - I'd like to learn some VBA.

The way I think I can do this is by making a macro that matches the
cell reference to the pivot table and if the values are not equal , to
color the cell blue.

Any help is appreciated

Tom