Interface IAboveBelowAverage

Represents the above or below conditional formatting rule. Applying this rule to a range helps you highlight the cells which contain values above or below the average of selected range.

Namespace: Syncfusion.XlsIO

Assembly: Syncfusion.XlsIO.Base.dll

Syntax

public interface IAboveBelowAverage

Properties

AverageType

Specifies whether the conditional formatting rule looks for cell values above or below the range average or standard deviation.

Declaration

ExcelCFAverageType AverageType { get; set; }

Property Value

Type
ExcelCFAverageType

StdDevValue

Specifies standard deviation number for AboveBelowAverage conditional formatting rule.

Declaration

int StdDevValue { get; set; }

Property Value

Type
System.Int32

Remarks

Valid only if AverageType is set to AboveStdDev or BelowStdDev.