TdxSpreadSheetConditionalFormattingRuleTopBottomValues.ValueType Property
Specifies whether the rule applies custom formatting to the absolute or relative number of cells.
Declaration
property ValueType: TdxSpreadSheetConditionalFormattingRuleTopBottomValuesValueType read; write; default tbvvtRank;
Property Value
Type | Default |
---|---|
TdxSpreadSheetConditionalFormattingRuleTopBottomValuesValueType | tbvvtRank |
Remarks
Use this property to specify how the “Top/Bottom Values” rule interprets the Value property value. Set the ValueType to tbvvtPercent or tbvvtRank to format either a percentage of the affected cell range(s) or only a specific number of cells, respectively. Refer to the TdxSpreadSheetConditionalFormattingRuleTopBottomValuesValueType type description for additional information.
Note
Use the Direction property to specify if the rule applies custom formatting cells containing the highest or lowest values within the affected cell range(s).
The default ValueType property value is tbvvtRank.
See Also