Once a month I receive an Excel 2000 spreadsheet with names and
address information.  There are 5200 rows and about 10 columns.  I
have been given the task to compare the current months extract to the
Previous and highlight any data that is new, removed, or changed.  I
am looking for a macro to do this and/or a 3rd party program that will
do it for me.
Thanks!

Hello teamministry-ga, 

 
I have located several Excel spreadsheet comparison programs that meet
your requirements. These programs compare and highlight new, removed,
or changed differences in Excel spreadsheets. I am providing links to
evaluation copies to try out before purchasing.


===========
Synkronizer
===========

Synkronizer is an easy-to-use, yet extremely powerful, Excel tool for
comparing and synchronizing Excel spreadsheets and Excel databases.
http://www.synkronizer.com/

“Synkronizer highlights the differences of the underlying
spreadsheets. Differences are highlighted with the following colors:”
 
   orange for different cell entries
 
   green for added and columns and rows
 
   light blue for deleted columns and rows
 
Download the shareware full working version of Synkronizer (30-day
trial).
http://www.synkronizer.com/download/sy70.exe

Order Synkronizer
http://www.synkronizer.com/e/order.html


Synkronizer is also known as Excel Compare 7.0

You can download and try it for an evaluation period from the
following websites:

Popular Shareware
http://www.popularshareware.com/Excel-Compare-download-2361.html

Download FreeTrial
http://www.downloadfreetrial.com/business/busi8905.html

WinPicks
http://www.winpicks.com/ShowDetails.asp?title=Excel+Compare



Here’s another excellent program by Formula Software.


=====================================
Formula Software - Excel Compare 1.0 
======================================

“Excel Compare is a tool that saves you the trouble of manual search
for differences and offers you computer-aided comparing of Excel
files. Excel Compare allows you to compare Excel files, Excel
spreadsheets and selected ranges of sheets. Excel Compare compares
data straight from your worksheets, and presents the results on a new
Excel sheet as a publication-quality report (Difference Report), that
is ready to print or save. The report displays the added, deleted and
changed data. Use this tool for the analysis of the made changes.”

Comparison: 

- Supports all versions of Microsoft Excel 
- The advanced comparison algorithm 
- Allows for comparing of any selected ranges of a sheet 
- Allows for comparing all files located in two different directories
- Allows for the comparison of all sheets with the same names in two
workbooks

Output report:
 
- Creates Difference Report as a new Excel sheet 
- Difference Report keeps the format of the compared data 
- Highlighting the cells that have changed 
- Allows for the division of the report into three parts: deleted,
added and changed data;

Formula Software, Inc.
http://www.formulasoft.com/xlsc.html


Download the evaluation version of Excel Compare 1.0 (500 Kb Zip
archive)
The trial version has some limitations such as a nag-screen and the
executions counter.
http://www.formulasoft.com/download.html


How to order
http://www.formulasoft.com/xlsc_order.html



==========================
WDD (Excel Comparison Tool)
==========================

WDD (WordDocDiff) is a file/folder comparison program with many
enhancements to specifically handle comparing Excel files.  Select
what sheets to compare, in addition to what rows and columns. Also,
when doing an Excel comparison you can choose to compare formulas or
values.

SoftInterface, Inc
http://www.softinterface.com/WDD/Excel/WDD_Excel.htm

Download - Free to Try
http://www.softinterface.com/DL/DL_Product.ASP


Search Criteria:

Excel comparison software
Compare Excel Files


I hope this helps!  If anything is unclear with my answer, please ask
for clarification.

Best Regards,
Bobbie7-ga

Just what I needed.  Very nice thank you!

You might try the "Conditional Formatting" feature in Excel.  In the
first cell to be compared, click the Format menu, then Conditional
Formatting.  A window will pop up.  In the first blank, choose "Cell
Value Is."  In the second, choose "not equal to." Then in the third
blank, click the little icon to the right, and find the item it will
be compared to (if it's in another worksheet tab in the same file, go
there and click the appropriate cell; if it's in another Excel file,
do the same thing).  Hit Enter.  Use the "Format..." button to choose
colors, fonts, etc.  Using the "Add..." button you can add even more
conditions.

To apply this conditional format to other cells (like a whole column),
select the cell you just formatted, click the paintbrush icon (Format
Painter) on the Formatting toolbar (should be near Copy and Paste),
and select the cells you want.

I hope this helps.  In the "Contents" portion of the Help file,
instructions can be found under Data in Worksheets>Formatting
Worksheets>Conditional Formats.