Mark differences in workbooks with color.
xlCompare
has 2 commands to highlight differences in source worksheets with colors:
Mark selected differences in Excel
. Cells, which are used in selected differences will be marked with color in Excel.
Mark all differences in Excel
. Cells, which are used in differences will be marked with color in Excel.
Each cell receives color, which is used in the Comparison Report.
Deleted cells are marked with red
Added cells are marked with green
Changed cells are marked with blue