Page tree
Skip to end of metadata
Go to start of metadata

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.

C#
vb.net

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

C#
vb.net
  • No labels