+ Reply to Thread
Results 1 to 2 of 2

Compare Two Excel Tabs For Differences

  1. #1
    Registered User
    Join Date
    02-12-2019
    Location
    India
    MS-Off Ver
    2016
    Posts
    2

    Post Compare Two Excel Tabs For Differences

    Hello,

    I want to compare 2 excel tabs (Old and new ) to highlight differences in new tab with yellow color and also highlight newly added entries in New tab with another color.
    Plz Help me with the vba code.

    Thanks In Advance

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,561

    Re: Compare Two Excel Tabs For Differences

    Hello im_neel and Welcome to Excel Forum
    An advanced search (top right corner of page) of this website brings up hundreds (at least) of threads on the subject.
    Keyword(s) "highlight differences sheets" (without quotation marks)
    be sure to check the box next to Posts.
    Everything else should be fine.
    One thread that looks similar is: https://www.excelforum.com/excel-pro...eadsheets.html
    If those threads don't address your issue then please upload a manually highlighted sample so that we may attempt to replicate the highlighting.
    To upload Attach a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 3
    Last Post: 12-10-2018, 03:51 PM
  2. Macro to Compare three columns between two tabs and display differences in a third
    By WildSpreadsheets in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-31-2017, 10:53 PM
  3. Replies: 0
    Last Post: 04-13-2015, 01:01 PM
  4. Replies: 2
    Last Post: 01-13-2014, 02:04 AM
  5. [SOLVED] Compare 2 Excel files with multiple tabs for differences (find changes)
    By bdicarlo1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-04-2013, 05:58 PM
  6. how do i compare two excel spreadsheets to indicate differences
    By Paul123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2006, 07:00 PM
  7. How do I compare excel spreadsheets, tracking the differences?
    By Nic in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2005, 03:30 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