TdxSpreadSheetConditionalFormattingRuleTopBottomValues.Value Property

Specifies the absolute or relative number of affected cells in target cell ranges.

Declaration

property Value: Integer read; write; default 10;

Property Value

Type	Default	Description
Integer	10	The number or percentage of affected cells in target cell ranges.

Remarks

Use Value and ValueType properties to specify the number of formatted top or bottom values in target cell ranges. The ValueType property value specifies the active Value property interpretation mode.

ValueType Property Values

tbvvtRank (default)

The Value property specifies the absolute number of affected cells in target cell ranges. The property value can be within the range between 1 and 1000.

tbvvtPercent

The Value property specifies the percentage of affected cells in target cell ranges. The property value can be within the range between 1 and 100. The calculated number of affected cells is always rounded down.

Default Value

The Value property’s default value is 10.