TdxSpreadSheetConditionalFormattingRuleCustomScaleStop.Value Property

Specifies a numeric threshold value for a conditional formatting rule.

Declaration

property Value: Variant read; write;

Property Value

Type
Variant

Remarks

Use this property to set a specific threshold value used for evaluating the cells affected by a conditional formatting rule. The rule can either use the Value property value directly or calculate the actual threshold value based on cell values within the affected cell area(s), depending on the ValueType property value. If ValueType is set to cssvtFormula, the conditional formatting controller interprets and evaluates the Value property value as an ExpressSpreadSheet-compatible formula expression. The controller uses the highest or lowest value within the affected cell area(s) instead of the Value property value if the ValueType property is set to cssvtLimitValue. Refer to the TdxSpreadSheetConditionalFormattingRuleCustomScaleStopValueType type description for detailed information on all possible threshold value interpretation options.

Use the ActualValue property to identify the threshold value that the conditional formatting rule is currently using to evaluate cells.

The default Value property value is 0.