'Declaration
 
Public Shared Function CreateAboveAverage( _
   Optional ByVal styleType As ConditionalFormattingStylePresets, _
   Optional ByVal underAverage As Boolean, _
   Optional ByVal equalAverage As Boolean _
) As ConditionalFormattingAboveAverage

'Usage
 
Dim styleType As ConditionalFormattingStylePresets
Dim underAverage As Boolean
Dim equalAverage As Boolean
Dim value As ConditionalFormattingAboveAverage
 
value = ConditionalFormatting.CreateAboveAverage(styleType, underAverage, equalAverage)

public static ConditionalFormattingAboveAverage CreateAboveAverage( 
   ConditionalFormattingStylePresets styleType,
   bool underAverage,
   bool equalAverage
)

Parameters

styleType

The ConditionalFormattingStylePreset. 

underAverage

Specifies if the formatting applies to Cells with values under the area's average value.

equalAverage

Specifies if the formatting applies to Cells with values equal to the area's average value.

Target Platforms: Windows 11, Windows 10, 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

Reference

ConditionalFormatting Class
ConditionalFormatting Members