Results 1 to 4 of 4

Thread: Spot the differences in Pivot tables

  1. #1

    Spot the differences in Pivot tables



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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)
    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

  2. #2
    Acolyte SUNNY KOW's Avatar
    Join Date
    Jul 2016
    Location
    Malaysia
    Posts
    41
    Articles
    0
    Hi try removing the $ from your formula eg =AfterClose!C12<>PreClose!C12 before applying it to your range.

  3. #3

    That worked !!! Thanks So much Sunny


    Quote Originally Posted by SUNNY KOW View Post
    Hi try removing the $ from your formula eg =AfterClose!C12<>PreClose!C12 before applying it to your range.

  4. #4
    Acolyte SUNNY KOW's Avatar
    Join Date
    Jul 2016
    Location
    Malaysia
    Posts
    41
    Articles
    0
    You are welcome

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •