+ Reply to Thread
Results 1 to 3 of 3

Compare Two Sheets and Highlight the Difference

  1. #1
    Registered User
    Join Date
    11-06-2021
    Location
    indonesia
    MS-Off Ver
    2016
    Posts
    1

    Compare Two Sheets and Highlight the Difference

    Hello, this is my 1st post so please go gentle on me if this question has already been asked 😁. I've search and haven't found some similarities with what I need so hopefully someone can help.

    I need to compare two sheets. Each sheet have ID and each ID have multiple column which the data need to be compared and highlighted if different. I've uploaded the example. The highlighted can be on the 2nd sheet or another sheet that the formula created.


    Any help would be greatly appreciated. Thank you for your time.
    Attached Files Attached Files

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Compare Two Sheets and Highlight the Difference

    Hi amrans20,
    try this
    Please Login or Register  to view this content.

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Compare Two Sheets and Highlight the Difference

    Another Option...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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. Compare two columns and highlight difference
    By Ryan0120 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2019, 10:06 AM
  2. VBA Compare rows and highlight the difference
    By Dvanacharla in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-03-2019, 05:40 PM
  3. [SOLVED] Compare Column and highlight difference
    By Barieq in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-30-2017, 07:35 AM
  4. [SOLVED] VBA Code compare two spread sheets and highlight difference errors out on no match
    By KumarPK in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-29-2016, 10:44 AM
  5. VBA Code compare two spread sheets and highlight difference errors out on no match
    By anfdrew in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-29-2016, 12:41 AM
  6. Compare Two Columns and Highlight the Difference
    By VickyVykciV in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-25-2014, 01:21 AM
  7. Macro that can compare sheets between 2 workbooks, highlight the difference
    By jeffboy29 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2013, 11:31 AM

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