It is frustrating when some one modified a twenty pages Excel file without give you details of changes. It takes a lot if time to find the changes manually without change tracking. Using Excel’s built in if function is a little faster, however, it still takes time to build all the if statement. There is a software package called CompareIt, which can compare Excel files, Word documents, and other files. It is handy to find changes in Excel.
Where to get Compare It
Compare It is a shareware. You can download it from http://download.cnet.com/Compare-It/3000-2248_4-10048256.html
Use Compare It to find Change in Excel
Here is an example of CompareIt finding changes in Excel