GrapeCity.Documents.Excel.ITop10.SetFirstPriority

SetFirstPriority Method

SetFirstPriority()

Sets the priority value for this conditional formatting rule to "1" so that it will be evaluated before all other rules on the worksheet.

Declaration

void SetFirstPriority()

Sub SetFirstPriority()

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.SetFirstPriority();
int priority = secondRule.Priority;