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.