ConditionalTopBottomRule Object (JavaScript API for Excel)

Represents the rule of the topbottom conditional format.

Properties

Property Type Description Req. Set
rank int The rank between 1 and 1000 for numeric ranks or 1 and 100 for percent ranks. 1.6
type string Format values based on the top or bottom rank. Possible values are: Invalid, TopItems, TopPercent, BottomItems, BottomPercent. 1.6

See property access examples.

Relationships

None

Methods

None