FormatConditionAboveBelow Enumeration

Constants which specify the manner in which cell values are compared when evaluating a AverageConditionalFormat.

Syntax

Visual Basic

'Declaration
 
Public Enum FormatConditionAboveBelow 
   Inherits System.Enum

C#

public enum FormatConditionAboveBelow : System.Enum 

Members

Member	Description
AboveAverage	The cell value must be above the average for the associated range in order to meet the associated condition.
AboveStandardDeviation	The cell value must be above the standard deviation for the associated range in order to meet the associated condition.
BelowAverage	The cell value must be below the average for the associated range in order to meet the associated condition.
BelowStandardDeviation	The cell value must be below the standard deviation for the associated range in order to meet the associated condition.
EqualAboveAverage	The cell value must be equal to or above the average for the associated range in order to meet the associated condition.
EqualBelowAverage	The 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 Server 2012, 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