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.UWP.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.

Extension Methods