GrapeCity.Documents.Excel.IIconSetCondition.Priority

Priority Property

Priority

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

The priority determines the order of evaluation when multiple conditional formatting rules exist in a worksheet. Priority values are unique 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:A5"].Value = new object[,] {{10}, {30}, {50}, {70}, {90}};
IIconSetCondition firstRule = worksheet.Range["A1:A5"].FormatConditions.AddIconSetCondition();
IIconSetCondition secondRule = worksheet.Range["A1:A5"].FormatConditions.AddIconSetCondition();
secondRule.Priority = 1;
int priority = secondRule.Priority;