TdxSpreadSheetConditionalFormattingRuleTopBottomValuesDirection Enum

Enumerates available cell formatting conditions in a Top/Bottom Values conditional formatting rule.

Declaration

TdxSpreadSheetConditionalFormattingRuleTopBottomValuesDirection = (
    tbvdTop,
    tbvdBottom
);

Members

Name
tbvdTop
tbvdBottom

Remarks

Options include:

Value	Description	Example
tbvdTop	In the “Top Values” mode, the rule applies custom formatting to a specific number of cells containing the highest values in the affected cell range(s). The actual number of formatted cells depends on the rule’s Value, ValueType property values, and/or the total number of affected cells.
tbvdBottom	In the “Bottom Values” mode, the rule applies custom formatting to a specific number of cells containing the lowest values in the affected cell range(s). The actual number of formatted cells is calculated in the same manner as in the “Top Values” mode.

Direct TdxSpreadSheetConditionalFormattingRuleTopBottomValuesDirection Type Reference

The Top/Bottom Values conditional formatting rule’s Direction property references the TdxSpreadSheetConditionalFormattingRuleTopBottomValuesDirection type.