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

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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