Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / ConditionalFormattingAboveAverage Class / ConditionalFormattingAboveAverage Constructor

When true, the values under the calculated average will be formatted.

The default value is false, which means that values above the average will be formatted.

When true, the values equal to the average will be formatted.
The ConditionalFormattingStylePresets that will determine how the Cells will be formatted.


In This Topic
    ConditionalFormattingAboveAverage Constructor
    In This Topic
    Syntax
    'Declaration
     
    
    Public Function New( _
       Optional ByVal underAverage As Boolean, _
       Optional ByVal equalAverage As Boolean, _
       Optional ByVal stylePreset As ConditionalFormattingStylePresets _
    )
    'Usage
     
    
    Dim underAverage As Boolean
    Dim equalAverage As Boolean
    Dim stylePreset As ConditionalFormattingStylePresets
     
    Dim instance As New ConditionalFormattingAboveAverage(underAverage, equalAverage, stylePreset)
    public ConditionalFormattingAboveAverage( 
       bool underAverage,
       bool equalAverage,
       ConditionalFormattingStylePresets stylePreset
    )

    Parameters

    underAverage

    When true, the values under the calculated average will be formatted.

    The default value is false, which means that values above the average will be formatted.

    equalAverage
    When true, the values equal to the average will be formatted.
    stylePreset
    The ConditionalFormattingStylePresets that will determine how the Cells will be formatted.
    Requirements

    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

    See Also