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 = 6HighestValue
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 = 4Percentile
Section titled "Percentile"The criteria is defined by a percentile rating.
Percentile = 2