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

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.

C#
vb.net

Values

Name

Description

FormulaEvaluation

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

CellValueBetween

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

CellValueEqualTo

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

CellValueGreaterThan

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

CellValueGreaterThanOrEqualTo

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

CellValueLessThan

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

CellValueLessThanOrEqualTo

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

CellValueNotBetween

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

CellValueNotEqualTo

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

  • No labels