PDA

View Full Version : Spot the differences in Pivot tables



kris21
2016-09-16, 05:24 PM
Hi Gurus,

I am trying to make a quality tool to spot differences . I have a workbook with 2 pivot tables in 2 different sheets. Each pivot tables are refreshed on different days of a week.

Pivot table 1 will be refreshed on a Friday and Pivot table 2 will be refreshed on a Monday.I would like to highlight the cells which are changed after Friday.The pivot table 2 is copy of pivot table 1 with cache sharing killed.

I tried to apply conditional formatting,and it works on single cell(something like this)

=AfterClose!$C$12<>PreClose!$C$12

The pivot table range is B10:J20 as of now . It is a pain to apply formatting to each cell individually. Is there a way to overcome this. Any thoughts on this would be highly appreciated.

Many Thanks in advance guys :)

SUNNY KOW
2016-09-17, 03:37 AM
Hi try removing the $ from your formula eg =AfterClose!C12<>PreClose!C12 before applying it to your range.

kris21
2016-09-18, 07:52 AM
That worked !!! Thanks So much Sunny :smile:



Hi try removing the $ from your formula eg =AfterClose!C12<>PreClose!C12 before applying it to your range.

SUNNY KOW
2016-09-18, 11:46 PM
You are welcome :cool2: