FormatConditionValueType Enumeration

Constants which identify the type of value which defines the criteria for a ColorScaleCriterion or IconCriterion.

Syntax

Visual Basic

'Declaration
 
Public Enum FormatConditionValueType 
   Inherits System.Enum

C#

public enum FormatConditionValueType : System.Enum 

Members

Member	Description
AutomaticMaximum	The longest data bar is proportional to the highest value across the associated range. Applicable only to the IconCriterion class.
AutomaticMinimum	The shortest data bar is proportional to the lowest value across the associated range. Applicable only to the IconCriterion class.
Formula	The criteria is defined by a formula.
HighestValue	The criteria is defined by the highest value across the associated range.
LowestValue	The criteria is defined by the lowest value across the associated range.
Number	The criteria is defined by a numeric value.
Percentage	The criteria is defined by a percentage.
Percentile	The criteria is defined by a percentile rating.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2