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.Portable.dll
Syntax
public interface IAboveBelowAverageProperties
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.