By default DiffEngineX uses the color red for a deleted cell, green for an added cell and light orange for a modified cell. However when is a modified cell not really a modified cell, but rather part of a row that has been entirely deleted and replaced by another row that just happens to be occupying its old position?
When Align Rows is specified, you select a column or columns that specify the parts of a row which make up its unique identifier. If the unique identifier is present in one worksheet, but not the other then the row has either been deleted or it is a new one. As such coloring the identifying part of the row light orange is inappropriate, as what really has happened is that there is one deletion and one addition.
The Extras dialog now has an option called Interpret modified cell as deletion and addition... which lets you choose how DiffEngineX colors the unique parts of each row.
You may wish to get Excel to sort the color highlighted sheets afterwards on a color of your choice (only available in Excel 2007) to get all the deleted and added rows to line up. Remember to only sort on the unique parts of a row.
When determining whether a row has been added or deleted, it is helpful to only look at the unique parts of each row.
* This option is now obsolete. We strongly recommend the use of Use Alignment Plus instead of this option.
