Excel.ConditionalTopBottomRule interface

Represents the rule of the top/bottom conditional format.

Remarks

rank	The rank between 1 and 1000 for numeric ranks or 1 and 100 for percent ranks.
type	Format values based on the top or bottom rank.

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

rank: number;

number

Format values based on the top or bottom rank.

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