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)
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
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)
Code:
=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