compare 2 excel files and highlight the differences

Posted on 2014-08-05
Last Modified: 2014-08-09
Hi Experts:

I have an excel files.  There are 10 columns in each file (1 worksheet).  Columns in file 1 and file 2 are the same but the data is slightly different.  

Is it possible to compare the 2 files and highlight (color) the rows or cells with a difference?  
Is it possible to reach to a solution with a vbscript?  

Thanks in advance.
Question by:Imran Asif
    LVL 16

    Expert Comment

    All Programs > Microsoft Office 2013 > Office 2013 Tools > Spreadsheet Compare 2013

    Don't know about VB script, but I think 2013 does it native.

    Author Comment

    by:Imran Asif
    I have escel 2010.


    Author Comment

    by:Imran Asif
    Is it possible to check/match value in column A and verify each row and highlight the differences?
    LVL 16

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now