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.

 public sealed class Comparison

Public NotInheritable Class Comparison

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.