GrapeCity.Documents.Excel.IFormatConditions.AddAboveAverage

AddAboveAverage Method

AddAboveAverage()

Returns a new IAboveAverage object representing a conditional formatting rule for the specified range.

Use the returned object to configure an average-based conditional formatting rule, such as whether cells are evaluated as above or below the average.

Declaration

IAboveAverage AddAboveAverage()

Function AddAboveAverage() As IAboveAverage

Returns

Type	Description
IAboveAverage	A new IAboveAverage object.

Examples

IRange range = worksheet.Range["A1:A5"];
range.Value = new object[,] {{1}, {2}, {3}, {4}, {10}};
IAboveAverage aboveAverage = range.FormatConditions.AddAboveAverage();
aboveAverage.Interior.Color = Color.Yellow;
aboveAverage.AboveBelow = AboveBelow.AboveAverage;