GrapeCity.Documents.Excel.IDataBar.Priority

Priority Property

Priority

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

The priority determines the order in which conditional formatting rules are evaluated when multiple rules exist on 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:B3"].Value = new object[,] {{10, 5}, {30, 15}, {20, 25}};
IDataBar firstDataBar = worksheet.Range["A1:A3"].FormatConditions.AddDatabar();
IDataBar secondDataBar = worksheet.Range["B1:B3"].FormatConditions.AddDatabar();
secondDataBar.Priority = 1;
int priority = secondDataBar.Priority;