GrapeCity.Documents.Excel.IFormatCondition.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[,] {{1, 2}, {0, 1}, {0, 0}, {0, 3}, {4, 5}};
IFormatCondition firstRule = (IFormatCondition) worksheet.Range["A1:A5"]
    .FormatConditions.Add(FormatConditionType.CellValue, FormatConditionOperator.Greater, "2", null);
firstRule.Interior.Color = Color.Yellow;
IFormatCondition secondRule = (IFormatCondition) worksheet.Range["B1:B5"]
    .FormatConditions.Add(FormatConditionType.Expression, FormatConditionOperator.None, "=B1>1", null);
secondRule.Interior.Color = Color.LightBlue;
secondRule.Priority = 1;
secondRule.SetLastPriority();
int priority = secondRule.Priority;