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
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: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.|