Comparing two workbooks and highlighting the differences
 

Hello,

I have GS072506.xls and GS072606.xls. Basically I run a daily report that
generates a spreadsheet. The spreadsheets always have the exact same row and
column format. However, the contents within the individual cells may or may
not change from day to day. I would like to find a way to compare 'todays'
spreadsheet with 'yesterdays' spreadsheet and have the changes highlighted in
BOLDED RED font on 'todays' spreadsheet.

For example, I would like to compare GS072606.xls (which was generated
today) with GS072506.xls (which was generated yesterday) and highlight (BOLD
RED font) the text that is in GS072606.xls but not in GS072506.xls .

Thank you!
Charles C.

Comparing two workbooks and highlighting the differences
 

You can use a formula that you insert into todays sheet in a blank
column to lookup the id number or any other identifying data for a
record and then use conditional formatting based on the result of that
formula.

Formula
=ISERROR(VLOOKUP(A2,'7-25-06'!$A$2:$C$5,2,FALSE))

I've attached a file that contains two sheets (you can change this to
to separate files) and compares the first sheet to the next using the
formula above and then applies conditional formatting to the data that
is not contained on the old sheet.


+-------------------------------------------------------------------+
|Filename: compare2sheets.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5107 |
+-------------------------------------------------------------------+

--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=565161

Comparing two workbooks and highlighting the differences
 

Thanks for the info....Could not download compare2sheets.zip. Would you send
it to ???? thanks!

"Excelenator" wrote:


You can use a formula that you insert into todays sheet in a blank
column to lookup the id number or any other identifying data for a
record and then use conditional formatting based on the result of that
formula.

Formula
=ISERROR(VLOOKUP(A2,'7-25-06'!$A$2:$C$5,2,FALSE))

I've attached a file that contains two sheets (you can change this to
to separate files) and compares the first sheet to the next using the
formula above and then applies conditional formatting to the data that
is not contained on the old sheet.


+-------------------------------------------------------------------+
|Filename: compare2sheets.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5107 |
+-------------------------------------------------------------------+

--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=565161