TdxSpreadSheetConditionalFormattingRuleTopBottomValues Class

A “Top/Bottom Values“ conditional formatting rule.

Declaration

TdxSpreadSheetConditionalFormattingRuleTopBottomValues = class(
    TdxSpreadSheetConditionalFormattingRuleStyleBased
)

Remarks

This rule applies custom formatting to a specific number of cells containing the highest or lowest values within one or more cell ranges affected by the rule.

The TdxSpreadSheetConditionalFormattingRuleTopBottomValues class provides the following members that allow you to:

Set or modify one or more cell ranges affected by the rule (Areas);
Determine whether the rule formats cells with the highest or lowest values (Direction);
Specify the absolute or relative number cells formatted by the rule (Value and ValueType);
Specify the cell style applied to the cells for which the rule’s formatting condition is met (Style);
Set the rule’s evaluation priority (Index);
Determine if the rule allows other rules with lower precedence to affect the same cells if its formatting condition is met (StopIfTrue);
Copy the rule between cells and/or cell ranges (Clone).

To create a “Top/Bottom Values” conditional formatting rule, you can:

Call a conditional formatting controller’s overloaded Add procedure (TdxSpreadSheetCustomConditionalFormatting.Add or TcxDataControllerConditionalFormatting.Add) and pass the rule’s class-reference (TdxSpreadSheetConditionalFormattingRuleTopBottomValues) as the ARuleClass parameter;
Call the Create constructor and pass the target conditional formatting controller as the AOwner parameter.

The conditional formatting controller’s Rules property provides indexed access to individual rules. To exopse a “Top/Bottom Values” rule’s type-specific members, cast the rule to the TdxSpreadSheetConditionalFormattingRuleTopBottomValues class.