How To Better View The Color Highlighted Worksheets
DiffEngineX creates two color highlighted workbooks after each comparison (in addition to a difference report typically called Sheet1). Red and green are used to highlight deletions and additions. Built-in Excel functionality can make viewing the color highlighted worksheets much easier. After you have got the hang of things you may want to do a second comparison with Hide Matching Rows turned on. Hide Matching Rows is found on the DiffEngineX Extras dialog box.
After DiffEngineX has produced its results, please follow the instruction given below.
The two color highlighted workbooks have the same names as the spreadsheets you selected for comparison, except for a number at their ends.
(Note: If you are comparing rows of data, rather than formula based sheets, remember to make sure your data is pre-sorted via Excel and that Align Rows is turned on. Align Columns, in most cases, can be left off.)
Excel 2007/Excel 2010
- Select the View tab
- Use the drop down list of workbooks from the Switch Windows button to bring to the front one of the two color highlighted sheets
- Select View Side by Side
- Select the other color highlighted workbook
- As you scroll up and down the two color highlighted sheets move in sync
- You can now easily spot what has been deleted and added
Excel 2003
- Select one of the two color highlighted workbooks from the Window menu
- Select Compare Side by Side with... from the Window menu
- Select the other color highlighted workbook
- As you scroll up and down the two color highlighted sheets move in sync
- You can now easily spot what has been deleted and added
tip 
Click here for a tip on how to make viewing the results much easier.
tip #2
In order to just see the new (green) or deleted (red) rows in both color highlighted worksheets, you can make use of Excel's built-in Filter capability. Just create a filter and then select a column to filter on Cell Color.
tip #3
If comparing rows of data, you may need Excel's Data tab to pre-sort. Then re-save before invoking DiffEngineX.
tip #4
If your region, language, location, date, time or number format settings have been altered or do not match the language version of Excel, you may need to turn on the DiffEngineX Internationalization option to stop errors.
tip #5
If you turn on Add Hyperlinks to aid navigation, the links work best if the workbooks being compared are initially closed (only applies to Excel 2003). For more details click here.