GrapeCity.Documents.Excel.IFormatConditions.AddTop10

AddTop10 Method

AddTop10()

Returns an ITop10 object representing a conditional formatting rule for the specified range.

Use the returned rule to configure whether the conditional formatting evaluates the top or bottom values in the range, and whether the rank is based on a count or a percentage.

Declaration

ITop10 AddTop10()

Function AddTop10() As ITop10

Returns

Type	Description
ITop10	A new ITop10 object.

Examples

IRange range = worksheet.Range["A1:A5"];
range.Value = new object[,] {{1}, {2}, {3}, {4}, {5}};
ITop10 top10 = range.FormatConditions.AddTop10();
top10.Interior.Color = Color.Yellow;
top10.TopBottom = TopBottom.Top;
top10.Rank = 3;