TdxSpreadSheetConditionalFormattingRuleCellIs Class

A “Cell Is“ conditional formatting rule.

Declaration

TdxSpreadSheetConditionalFormattingRuleCellIs = class(
    TdxSpreadSheetConditionalFormattingRuleExpression
)

Remarks

This rule applies custom formatting to all affected cells whose values meet the selected evaluation criterion (that is, within or outside the predefined range, above or below a specific value, etc.). Depending on the criterion, the rule can use a formula expression result, a numeric value, or any other value interpreted as a text string for comparison.

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

Set or modify one or more cell ranges affected by the rule (Areas);
Specify one or two ExpressSpreadSheet-compatible formula expressions whose results are compared to cell values within the affected area(s) (Expression and Expression2);
Switch between available cell evaluation modes (ComparisonOperator);
Specify the style settings applied to cells for which the formatting conditions are met (Style);
Set the rule’s evaluation priority (Index);
Determine if the “Cell Is” rule allows other rules with lower precedences to affect the same cells for which the formatting conditions are met (StopIfTrue);
Copy the rule between cells and/or cell ranges (Clone).

To create a “Cell Is” 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 (TdxSpreadSheetConditionalFormattingRuleCellIs) as the ARuleClass parameter;
Call the Create constructor and pass the target conditional formatting controller as a parameter.

The conditional formatting controller’s Rules property provides indexed access to individual rules. To expose a “Cell Is” rule’s type-specific members, cast the rule to the TdxSpreadSheetConditionalFormattingRuleCellIs class.