GrapeCity.Documents.Excel.IFormatCondition.Priority

Priority Property

Priority

Gets or sets the priority value of the conditional formatting rule.

The priority is a unique positive integer within the worksheet, so changing the priority of one rule can shift the priority values of other rules.

Declaration

int Priority { get; set; }

Property Priority As Integer

Examples

worksheet.Range["A1:B5"].Value = new object[,] {{1, 2}, {0, 1}, {0, 0}, {0, 3}, {4, 5}};
IFormatCondition condition = (IFormatCondition) worksheet.Range["B1:B5"]
    .FormatConditions.Add(FormatConditionType.Expression, FormatConditionOperator.None, "=A1", null);
condition.Interior.Color = Color.Yellow;
int priority = condition.Priority;