GrapeCity.Documents.Excel.IAboveAverage.AboveBelow

AboveBelow Property

AboveBelow

Returns one of the constants of the AboveBelow enumeration, specifying how the conditional formatting rule compares cell values with the range average or a standard deviation threshold.

Use this property to determine whether the rule evaluates values that are above average, below average, equal to or above average, equal to or below average, above the standard deviation, or below the standard deviation.

Declaration

AboveBelow AboveBelow { get; set; }

Property AboveBelow As AboveBelow

Examples

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