GrapeCity.Documents.Excel.AboveBelow

AboveBelow Enum

Specifies how a rule checks values relative to the average or standard deviation.

This enum is used with AboveBelow to control whether the rule matches values that are above, below, equal to or above, equal to or below the average, or above or below the standard deviation.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum AboveBelow

Public Enum AboveBelow

Examples

worksheet.Range["A1:A5"].Value = new object[,] {
    {10}, {20}, {30}, {40}, {100}
};
IAboveAverage averageCondition = worksheet.Range["A1:A5"].FormatConditions.AddAboveAverage();
averageCondition.AboveBelow = AboveBelow.AboveAverage;
averageCondition.Interior.Color = Color.Yellow;

Fields

Name	Description
AboveAverage	Specifies above average.
AboveStdDev	Specifies above the standard deviation.
BelowAverage	Specifies below average.
BelowStdDev	Specifies below the standard deviation.
EqualAboveAverage	Specifies equal or above average.
EqualBelowAverage	Specifies equal or below average.