GrapeCity.Documents.Excel.IFormatCondition.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[,] {{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.SetFirstPriority();
int priority = secondRule.Priority;