TdxSpreadSheetConditionalFormattingRuleTopBottomValues.Direction Property

Specifies if the rule applies custom formatting to cells containing the highest or lowest values.

Declaration

property Direction: TdxSpreadSheetConditionalFormattingRuleTopBottomValuesDirection read; write; default tbvdTop;

Property Value

Type	Default	Description
TdxSpreadSheetConditionalFormattingRuleTopBottomValuesDirection	tbvdTop	Enumerates available types of a “Top/Bottom Values” conditional formatting rule.

Remarks

You can use this property to switch the “Top/Bottom Values” conditional formatting rule between the “Top” and “Bottom” modes. Set the Direction property to tbvdBottom or tbvdTop to apply custom formatting to a number of cells containing the lowest or highest values within the cell range(s) affected by the rule. Use the Value and ValueType properties to define the actual number of the custom formatted cells.

To mark cells containing both the highest and lowest values in the target cell range(s), you need to create two “Top/Bottom Values” conditional formatting rules with different Direction property values and the identical lists of affected areas. Refer to the TdxSpreadSheetConditionalFormattingRuleTopBottomValuesDirection type description for additional information on all available options.

The default Direction property value is tbvdTop.