TdxSpreadSheetConditionalFormattingRuleThreeColorScale.MiddleValue Property

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

Declaration

property MiddleValue: TdxSpreadSheetConditionalFormattingRuleColorScaleStop index 1 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 MiddleValue.Value and MiddleValue.ValueType properties specify the midpoint threshold value and how the conditional formatting controller interprets it, respectively. Use the MiddleValue.Color property to set the corresponding key gradient point. The intermediate threshold value’s default color is determined by the DefaultMiddleValueColor writable typed constant.

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