vcl-dxspreadsheetconditionalformatting-dot-tdxspreadsheetcustomconditionalformattingrule.md
Specifies the conditional formatting rule’s index in the parent conditional formatting controller.
property Index: Integer read; write;
| Type | Description |
|---|---|
| Integer |
The rule’s index that specifies the conditional formatting rule’s priority.
The lower the index, the higher the rule’s priority. If the index is 0, the rule has the highest priority.
|
The conditional formatting controller assigns consecutive numbers starting from 0 to the Index property of every rule according to its order of creation. The Index property value also determines the rule’s evaluation priority and position in the Conditional Formatting Rules Manager dialog:
You can use the Index property to change the conditional formatting rule’s precedence. For instance, if the Index property is set to 0, the rule has the highest priority. Since all rule indexes within the same conditional formatting controllers are unique, all other rules automatically update their Index property values.
The conditional formatting controller evaluates rule precedences only if two or more rules affect the same areas. To prevent all rules with lower priority from affecting the same areas, set the StopIfTrue property to True.
Only the following TdxSpreadSheetCustomConditionalFormattingRule class descendants expose the StopIfRule property:
TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverageAn Above or Below Average conditional formatting rule.TdxSpreadSheetConditionalFormattingRuleCellIsA Cell Is conditional formatting rule.TdxSpreadSheetConditionalFormattingRuleDuplicateValuesA Duplicate Values conditional formatting rule.TdxSpreadSheetConditionalFormattingRuleExpressionAn Expression conditional formatting rule.TdxSpreadSheetConditionalFormattingRuleTopBottomValuesA Top/Bottom Values conditional formatting rule.TdxSpreadSheetConditionalFormattingRuleUniqueValuesA Unique Values conditional formatting rule. See Also
TdxSpreadSheetCustomConditionalFormattingRule.StopIfTrue Property
TdxSpreadSheetCustomConditionalFormattingRule Class