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.| |
Page History
Overview
Content Tools