FormatConditions.AddCompareColumns Method
Returns a new CompareColumns object representing a conditional formatting rule for the specified range.
Version Information
Version Added: Excel
Syntax
expression.AddCompareColumns
expression A variable that represents a FormatConditions object.
Return Value
CompareColumns object
Remarks
The CompareColumns object can be used to highlight specific cells within a range of cells based on a comparison operator. For example, in an inventory worksheet sorted by categories, you can highlight in yellow the products with fewer than 10 items on hand. Or, in a retail store summary worksheet, you can identify all stores with profits greater than 10 percent, sales volumes less than $100,000, and region equal to "Southeast."