Skip to main content

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