[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

compare 2 excel files and highlight the differences

Posted on 2014-08-05
4
Medium Priority
?
206 Views
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.
0
Comment
Question by:Imran Asif
  • 2
  • 2
4 Comments
 
LVL 16

Expert Comment

by:Chris H
ID: 40242834
All Programs > Microsoft Office 2013 > Office 2013 Tools > Spreadsheet Compare 2013

http://office.microsoft.com/en-us/excel-help/what-you-can-do-with-spreadsheet-inquire-HA102835926.aspx

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

Author Comment

by:Imran Asif
ID: 40242895
I have escel 2010.

Thanks,
0
 

Author Comment

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

Accepted Solution

by:
Chris H earned 2000 total points
ID: 40242903
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

831 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