Identical to CompareRanges, but with additional parameters to control the colors that are used in reports.
Applies to
SYNTAX
Set result = expression.CompareRangesWithColors(range1, range2, testFormulas, ignoreCase, styleA1, highlightDifferences, writeReport, groupEquivalentChanges, win32ModifiedCellColor, win32DeletedCellColor, win32AddedCellColor, win32BlankAlignmentRowColor, win32BlankAlignmentColumnColor, win32ArrayMembershipColor, win32RangeSelectionColor)
expression Required. An expression that returns an IOAKAPI object.
result An ICompareResult object that gives access to the results of the comparison.
range1, range2, testFormulas, ignoreCase, styleA1, highlightDifferences, writeReport, groupEquivalentChanges: These parameters are identical to those of the CompareRanges method.
win32ModifiedCellColor, win32DeletedCellColor, win32AddedCellColor, win32BlankAlignmentRowColor, win32BlankAlignmentColumnColor, win32ArrayMembershipColor, win32RangeSelectionColor: Required Longs which specify the colors to be used for when marking comparison results on a worksheet.
These colors are equivalent to the ones which may be specified through the user interface by pressing the Set Colors button in the dialog presented when the OAK Review | Compare | Ranges command is invoked.
