GrapeCity.Documents.Excel.ITop10.SetLastPriority

SetLastPriority Method

SetLastPriority()

Sets the evaluation order for this conditional formatting rule so it is evaluated after all other rules on the worksheet.

Declaration

void SetLastPriority()

Sub SetLastPriority()

Examples

worksheet.Range["A1:B5"].Value = new object[,] {{10, 5}, {30, 15}, {20, 25}, {50, 35}, {40, 45}};
ITop10 firstRule = worksheet.Range["A1:A5"].FormatConditions.AddTop10();
firstRule.Interior.Color = Color.Yellow;
ITop10 secondRule = worksheet.Range["B1:B5"].FormatConditions.AddTop10();
secondRule.Interior.Color = Color.LightBlue;
secondRule.Priority = 1;
secondRule.SetLastPriority();
int priority = secondRule.Priority;