FormatConditionValueType
Constants which identify the type of value which defines the criteria for a [[ColorScaleCriterion]] or [[IconCriterion]].
Enumeration Members
Section titled "Enumeration Members"AutomaticMaximum
Section titled "AutomaticMaximum"The longest data bar is proportional to the highest value across the associated range. Applicable only to the [[IconCriterion]] class.
AutomaticMaximum = 7AutomaticMinimum
Section titled "AutomaticMinimum"The shortest data bar is proportional to the lowest value across the associated range. Applicable only to the [[IconCriterion]] class.
AutomaticMinimum = 6Formula
Section titled "Formula"The criteria is defined by a formula.
Formula = 3HighestValue
Section titled "HighestValue"The criteria is defined by the highest value across the associated range.
HighestValue = 5LowestValue
Section titled "LowestValue"The criteria is defined by the lowest value across the associated range.
LowestValue = 4Number
Section titled "Number"The criteria is defined by a numeric value.
Number = 0Percentage
Section titled "Percentage"The criteria is defined by a percentage.
Percentage = 1Percentile
Section titled "Percentile"The criteria is defined by a percentile rating.
Percentile = 2