.
| 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# |
|---|---|---|
| Wiki Markup | ||
{description}
{excerpt}The value of [Condition.Comparison|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.{excerpt}
{signature:C#}
public sealed class Comparison
| ||
| Signature | ||
{signature}{signature:vb.net | vb.net | }
Public NotInheritable Class Comparison
|
| Values |
|---|
...
Name
...
Description
...
The condition's Formula1 property will be a
formula that evaluates to True or False.
...
Conditional formatting will be applied if a cell's value is
between two specified values.
...
Conditional formatting will be applied if a cell's value is
equal to the specified value.
...
Conditional formatting will be applied if a cell's value is greater than the
specified value.
...
Conditional formatting will be applied if a cell's value is greater than or
equal to the specified value.
...
Conditional formatting will be applied if a cell's value is
less than the specified value.
...
Conditional formatting will be applied if a cell's value is less than or equal
to the specified value.
...
Conditional formatting will be applied if a cell's value is
not between two specified values.
...
{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.| |