advanced excel ms training - Comparing Models

Hi Tim. There doesn't seem to be a straight worksheet comparison tool in Excel, so I'm thinking there must be a downloadable add-in out there to perform this function. Secondly, you could feasibly copy and paste the cell values into Word as a table and then use its Compare function to highlight alterations between versions. Thirdly, there's a package called Deltaview which is used by law firms to compare Word documents, which might be able to generate Excel comparisons.

Finally, you could use worksheet formulas to compare cells and then change cell formatting if a difference is found, but that would add in a whole extra laying of formulae ontop of the model, so I wouldn't advise it.

Hope this helps,

Anthony