IntroductionContact UsCopyrightOn-line Help LibraryWhich file formats are supportedComparison StrategyxlCompare CommandsFile | OpenFile | Recent ComparisonsCompare | BooksCompare | SheetsCompare | ModulesCompare | OptionsView | LayoutView | Ignore FormattingTools | RecalculatexlCompare ActivationHow to activate xlCompare on the another PC?How to restore xlCompare on my PC?License detailsHow to remove trial limits?General Questions Extended View modeDisplay differences in Extended ViewFilter differencesMerge data from two worksheetsUpdate records on the worksheetDuplicate RemoverGet duplicates between 2 listsExtract Unique RecordsCommand Line modeSave changes in the workbookSave comparison report on diskWorking with TXT and CSV filesFilter data you want to compareIgnore error valuesTrace Formula CalculationsMinimize Difference BrowserSynchronize rows and columnsMark differences (changed cells) with colorDatabase ComparisonCompare worksheets As DatabaseManage Primary KeysHide Equal ModulesFilter cells on the worksheetJoin 2 lists in ExcelFind duplicates in ExcelRemove duplicates in ExcelRemove empty rows on the worksheetBulk Merge operationsBulk Undo operationHighlight only results you needVersion ControlUse xlCompare with SVN to resolve conflictsCompare Visual Basic ProjectsCompare controls on the VB FormsMerge controls on the formsMerge contents of the VBA ModulesI've found a problemSending bugreports to Spreadsheet Tools
How to mark differences with color
When you've got list of changed cell, added or deleted rows, you can apply color formatting to each cell to work with this data later. xlCompare displays color-coded comparison report as a result of its work. Same formatting is used to mark differences:
- Yellow color - for changed cells
- Red color - for deleted cells
- Green color - for added cells
For example, you've got this Difference Browser:
Pencil icon (we've put it into red square) is a command which marks all changes with color.
Before using it you should know, that command it applied to the branch selected in the Difference Browser. In this example you see on the image it will be applied to the J9 cell only.
To apply color formatting to all cells on the sheet you should select node which represents worksheets (OLD - NEW) in this example.
If you select root node Sheets - formatting is applied to all changed cells.
As you understand, if this command is applied to the VB Project comparison results, it does nothing. Items in the VB Project can't be formatted with color.
This command modifies contents of the workbook, so if you want to work with this data later, you should save the workbook.