TdxSpreadSheetConditionalFormattingRuleThreeColorScale.MaxValue Property

Specifies the “Three Color Scale“ conditional formatting rule’s maximum threshold value and the corresponding key gradient color.

Declaration

property MaxValue: TdxSpreadSheetConditionalFormattingRuleColorScaleStop index 2 read; write;

Property Value

Type
TdxSpreadSheetConditionalFormattingRuleColorScaleStop

Remarks

The backgrounds of all cells affected by the rule are painted with colors of the gradient built using the three key points corresponding to the minimum, medium, and maximum threshold values. To set the thresholds and their key gradient points, use the MinValue, MiddleValue, and MaxValue properties.

The MaxValue.Value and MaxValue.ValueType properties specify the maximum threshold value and how the conditional formatting controller interprets it, respectively. Use the MaxValue.Color property to set the corresponding key gradient point. The maximum threshold value’s default color is determined by the DefaultMaxValueColor writable typed constant.

Refer to the TdxSpreadSheetConditionalFormattingRuleColorScaleStop class description for detailed information on all available threshold value and gradient point settings.