GrapeCity.Documents.Excel.ITop10.TopBottom

TopBottom Property

TopBottom

Gets or sets a TopBottom value that determines whether values are ranked from the top or bottom.

Use this property to inspect whether the conditional formatting rule evaluates the highest values or the lowest values in the applied range.

Declaration

TopBottom TopBottom { get; set; }

Property TopBottom As TopBottom

Examples

worksheet.Range["A1:A5"].Value = new object[,] {{10}, {30}, {20}, {50}, {40}};
ITop10 top10 = worksheet.Range["A1:A5"].FormatConditions.AddTop10();
top10.Interior.Color = Color.Yellow;
top10.TopBottom = TopBottom.Bottom;
TopBottom topBottom = top10.TopBottom;