TdxSpreadSheetConditionalFormattingRuleThreeColorScale Class
A “Three Color Scale“ conditional formatting rule.
Declaration
TdxSpreadSheetConditionalFormattingRuleThreeColorScale = class(
TdxSpreadSheetConditionalFormattingRuleCustomColorScale
)
Remarks
This rule differentiates numeric values within one or more affected cell ranges by painting backgrounds of the corresponding cells with colors on a gradient built using the three specified key point colors corresponding to the high, medium, and low value thresholds.
The TdxSpreadSheetConditionalFormattingRuleThreeColorScale class provides the following members that allow you to:
Designate one or more cell ranges to which the rule applies (Areas);
Set the low, medium, and high threshold values and their corresponding colors (MinValue, MiddleValue, and MaxValue);
Change the default key gradient point colors (DefaultMinValueColor, DefaultMiddleValueColor, and DefaultMaxValueColor);
Set the rule’s evaluation priority (Index);
Copy the rule between cells and/or cell ranges (Clone).
To create a “Three Color Scale” conditional formatting rule, you can:
Call a conditional formatting controller’s overloaded Add procedure (TdxSpreadSheetCustomConditionalFormatting.Add or TcxDataControllerConditionalFormatting.Add) and pass the ruler’s class-reference (TdxSpreadSheetConditionalFormattingRuleThreeColorScale) 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 “Three Color Scale” rule’s type-specific members, cast the rule to the TdxSpreadSheetConditionalFormattingRuleThreeColorScale class.