<div>
All Programs &gt;&nbsp;Microsoft Office 2013 &gt;&nbsp;Office 2013 Tools &gt;&nbsp;Spreadsheet Compare 2013<br />
<br />
<a href="http://office.microsoft.com/en-us/excel-help/what-you-can-do-with-spreadsheet-inquire-HA102835926.aspx" rel="ugc">http://office.microsoft.com/en-us/excel-help/what-you-can-do-with-spreadsheet-inquire-HA102835926.aspx</a><br />
<br />
Don't know about VB script, but I think 2013 does it native.
</div>


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 [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.

<div>
I have escel 2010.<br />
<br />
Thanks,
</div>


<div>
Is it possible to check/match value in column A and verify each row and highlight the differences?
</div>


Is it possible to check/match value in column A and verify each row and highlight the differences?

<div>
<div class="content wysiwyg-content">
Hi Experts:<br />
<br />
I have an excel files. &nbsp;There are 10 columns in each file (1 worksheet). &nbsp;Columns in file 1 and file 2 are the same but the data is slightly different. &nbsp;<br />
<br />
Is it possible to compare the 2 files and highlight (color) the rows or cells with a difference? &nbsp;<br />
Is it possible to reach to a solution with a vbscript? &nbsp;<br />
<br />
Thanks in advance.
</div>
</div>


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.

compare 2 excel files and highlight the differences

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.