Excel.ConditionalTopBottomRule interface

Represents the rule of the top/bottom conditional format.

[ API set: ExcelApi 1.6 ]

Properties

rank

The rank between 1 and 1000 for numeric ranks or 1 and 100 for percent ranks.

[ API set: ExcelApi 1.6 ]

type

Format values based on the top or bottom rank.

[ API set: ExcelApi 1.6 ]

Property Details

rank

The rank between 1 and 1000 for numeric ranks or 1 and 100 for percent ranks.

[ API set: ExcelApi 1.6 ]

rank: number;
Property Value
number

type

Format values based on the top or bottom rank.

[ API set: ExcelApi 1.6 ]

type: Excel.ConditionalTopBottomCriterionType | "Invalid" | "TopItems" | "TopPercent" | "BottomItems" | "BottomPercent";
Property Value
Excel.ConditionalTopBottomCriterionType | "Invalid" | "TopItems" | "TopPercent" | "BottomItems" | "BottomPercent"