Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / ConditionalFormatting Class / CreateAboveAverage Method
The ConditionalFormattingStylePreset. 
Specifies if the formatting applies to Cells with values under the area's average value.
Specifies if the formatting applies to Cells with values equal to the area's average value.
Example


In This Topic
    CreateAboveAverage Method
    In This Topic
    Creates an AboveAverage ConditionalFormatting.
    Syntax
    '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.
    Example
    ConditionalFormatting cf = ConditionalFormatting.CreateAboveAverage().AddArea( "A1", "C3" );
doc.Worksheets[ 0 ].ConditionalFormattings.Add( cf );
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    ConditionalFormatting Class
    ConditionalFormatting Members

    Send Feedback