+ Reply to Thread
Results 1 to 4 of 4

Compare/Contrast Two Tables Using Conditional Formatting

  1. #1
    Registered User
    Join Date
    07-28-2014
    Location
    Boston, MA
    MS-Off Ver
    2003
    Posts
    4

    Compare/Contrast Two Tables Using Conditional Formatting

    Hi All,

    I have two pivot tables of data that I would like to compare & contrast by highlighting the cells that are the same between the tables in green and the cells that differ between the tables in red.

    I imagine this could be done without VBA, however one conundrum I am running into is that table1 has more information than table2. Thus, not all of the information in the two tables geometrically match up. Nonetheless, the info that does match up is paired by the same primary and secondary keys.

    Any recommendations on how I may proceed?

    Thank you!
    AjKim

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,676

    Re: Compare/Contrast Two Tables Using Conditional Formatting

    This may be possible with conditional formatting but we need much more specific information about data layout. Please post a file with sample data. Define what "cells that are the same" means; what the primary and secondary keys and what do you mean by that (I know what a key is but primary and secondary suggests there is some precedence, which makes sense for sorting but not for matching). If the tables do match up, what do want to do with the cells in one that don't exist at all in the other?
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    07-28-2014
    Location
    Boston, MA
    MS-Off Ver
    2003
    Posts
    4

    Re: Compare/Contrast Two Tables Using Conditional Formatting

    Thank you so much for your response.

    You'll see that it is a two way pivot table. By the "same" I meant that the actual data that populates both tables. Maybe primary and secondary keys wasn't the right phrasing.

    For the cells that exist in one but not the other, we can leave those alone.

    For example, what I would want marked green in table 1 is 7/12/2015, player ID 2, the value in table 1 is 7. This matches with table 2.

    What I would want marked red in table 1 is 7/26/2015, player ID 9, the value in table 1 is 7. The value in table 2 for 7/26/2015 and player ID 9 is 5. These do not match up.

    Does this clarify it all?
    Attached Files Attached Files
    Last edited by AJKim; 06-17-2015 at 04:16 PM. Reason: Fix the sample file

  4. #4
    Registered User
    Join Date
    07-28-2014
    Location
    Boston, MA
    MS-Off Ver
    2003
    Posts
    4

    Re: Compare/Contrast Two Tables Using Conditional Formatting

    Attached is a corrected and easier to work with version of the sample file.

    Sample LayoutV2.xlsx

    Thanks again for all of your help this is saving me haha

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting for Pivot tables
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 04-14-2015, 12:18 AM
  2. [SOLVED] Conditional Formatting across two tables?
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-20-2012, 12:20 PM
  3. Conditional Formatting in Tables
    By Uziel in forum Excel General
    Replies: 2
    Last Post: 05-14-2010, 03:28 PM
  4. Conditional Formatting for texts, tables, etc
    By gss in forum Excel General
    Replies: 3
    Last Post: 07-08-2009, 02:35 AM
  5. Conditional Formatting Help-What I want to do is compare them
    By manic2511 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-14-2007, 03:55 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1