Version

FormatConditionAboveBelow Enumeration

Constants which specify the manner in which cell values are compared when evaluating a AverageConditionalFormat.
Syntax
'Declaration
 
Public Enum FormatConditionAboveBelow 
   Inherits System.Enum
public enum FormatConditionAboveBelow : System.Enum 
Members
MemberDescription
AboveAverageThe cell value must be above the average for the associated range in order to meet the associated condition.
AboveStandardDeviationThe cell value must be above the standard deviation for the associated range in order to meet the associated condition.
BelowAverageThe cell value must be below the average for the associated range in order to meet the associated condition.
BelowStandardDeviationThe cell value must be below the standard deviation for the associated range in order to meet the associated condition.
EqualAboveAverageThe cell value must be equal to or above the average for the associated range in order to meet the associated condition.
EqualBelowAverageThe cell value must be equal to or below the average for the associated range in order to meet the associated condition.
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

See Also