TdxSpreadSheetConditionalFormattingRuleTwoColorScale Class
A “Two Color Scale“ conditional formatting rule.
Declaration
TdxSpreadSheetConditionalFormattingRuleTwoColorScale = class(
TdxSpreadSheetConditionalFormattingRuleCustomColorScale
)Remarks
This rule differentiates all cells within one or more affected areas by painting their backgrounds with colors on a gradient between the two specified colors corresponding to the minimum and maximum threshold values.
The TdxSpreadSheetConditionalFormattingRuleTwoColorScale class provides the following members that allow you to:
Designate one or more cell ranges to which the rule applies (Areas);
Set the minimum/maximum threshold values and their corresponding colors (MinValue and MaxValue);
Change the default key gradient point colors (DefaultMinValueColor and DefaultMaxValueColor);
Set the rule’s evaluation priority (Index);
Copy the rule between cells and/or cell ranges (Clone).
To create a “Two Color Scale” 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 (TdxSpreadSheetConditionalFormattingRuleTwoColorScale) 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 expose a “Two Color Scale” rule’s type-specific members, cast the rule to the TdxSpreadSheetConditionalFormattingRuleTwoColorScale class.