Condition.ChangeCondition(Condition.Comparison, String)

Description

Resets the current Condition's Comparison type and formula. The method takes one formulas, and therefore must take a Comparison that requires one formulas, such as Comparison.CellValueLessThan.

Parameters

comparisonType

The type of comparison Excel will use when comparing a cell value to the result of formula. The comparison type must require only one formula and may be set to one of the following values: Comparison.FormulaEvaluates, Comparison.CellValueLessThan, Comparison.CellValueGreaterThan, Comparison.CellValueLessThanOrEqualTo, Comparison.CellValueGreaterThanOrEqualTo, Comparison.CellValueEqualTo, or Comparison.CellValueNotEqualTo.

formula

The result of this formula will be compared to each cell value in the set of cells associated with the conditional format.

Examples