Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

The value of Condition.Comparison determines whether the value of a conditionally formatted cell will be compared with one or two other values, or if a formula will be evaluated for each cell.

Signature
C#
C#
 public sealed class Comparison
{signature}{signature:
}
Signature
vb.net
vb.net
Public NotInheritable Class Comparison
{signature}
{values}
||Name||Description||
|{anchor:FormulaEvaluation}FormulaEvaluation|The condition's [Formula1|Condition.Formula1] property will be a
          formula that evaluates to True or False.|
|{anchor:CellValueBetween}CellValueBetween|Conditional formatting will be applied if a cell's value is
          between two specified values.|
|{anchor:CellValueEqualTo}CellValueEqualTo|Conditional formatting will be applied if a cell's value is
          equal to the specified value.|
|{anchor:CellValueGreaterThan}CellValueGreaterThan|Conditional formatting will be applied if a cell's value is greater than the
          specified value.|
|{anchor:CellValueGreaterThanOrEqualTo}CellValueGreaterThanOrEqualTo|Conditional formatting will be applied if a cell's value is greater than or
          equal to the specified value.|
|{anchor:CellValueLessThan}CellValueLessThan|Conditional formatting will be applied if a cell's value is
          less than the specified value.|
|{anchor:CellValueLessThanOrEqualTo}CellValueLessThanOrEqualTo|Conditional formatting will be applied if a cell's value is less than or equal
          to the specified value.|
|{anchor:CellValueNotBetween}CellValueNotBetween|Conditional formatting will be applied if a cell's value is
          not between two specified values.|
|{anchor:CellValueNotEqualTo}CellValueNotEqualTo|Conditional formatting will be applied if a cell's value is
          not equal to the specified value.|
Values

Name

Description

Anchor
FormulaEvaluation
FormulaEvaluation
FormulaEvaluation

The condition's Formula1 property will be a
formula that evaluates to True or False.

Anchor
CellValueBetween
CellValueBetween
CellValueBetween

Conditional formatting will be applied if a cell's value is
between two specified values.

Anchor
CellValueEqualTo
CellValueEqualTo
CellValueEqualTo

Conditional formatting will be applied if a cell's value is
equal to the specified value.

Anchor
CellValueGreaterThan
CellValueGreaterThan
CellValueGreaterThan

Conditional formatting will be applied if a cell's value is greater than the
specified value.

Anchor
CellValueGreaterThanOrEqualTo
CellValueGreaterThanOrEqualTo
CellValueGreaterThanOrEqualTo

Conditional formatting will be applied if a cell's value is greater than or
equal to the specified value.

Anchor
CellValueLessThan
CellValueLessThan
CellValueLessThan

Conditional formatting will be applied if a cell's value is
less than the specified value.

Anchor
CellValueLessThanOrEqualTo
CellValueLessThanOrEqualTo
CellValueLessThanOrEqualTo

Conditional formatting will be applied if a cell's value is less than or equal
to the specified value.

Anchor
CellValueNotBetween
CellValueNotBetween
CellValueNotBetween

Conditional formatting will be applied if a cell's value is
not between two specified values.

Anchor
CellValueNotEqualTo
CellValueNotEqualTo
CellValueNotEqualTo

Conditional formatting will be applied if a cell's value is
not equal to the specified value.