Condition.ChangeCondition(Condition.Comparison, String, String)

Description

Resets the current Condition's Comparison type and minimum and maximum formulas. The method takes two formulas, and therefore must take a Comparison that requires two formulas, such as Comparison.CellValueBetween.

Parameters

comparisonType

The type of comparison Excel will use when comparing a cell value to formula1 and formula2. The comparison type must require two formulas and may be set to one of the following values: Comparison.CellValueBetween or Comparison.CellValueNotBetween.

formula1

The formula to use for the minumum value.

formula2

The formula to use for the maximum value.

Examples