Top10
Contents
[
Hide
]Top10 class
Describe the Top10 conditional formatting rule. This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
Constructors
| Name | Description |
|---|---|
| Top10 |
Properties
| Name | Type | Description |
|---|---|---|
| IsPercent | boolean | Get or set whether a “top/bottom n” rule is a “top/bottom n percent” rule. Default value is false. |
| IsBottom | boolean | Get or set whether a “top/bottom n” rule is a “bottom n” rule. Default value is false. |
| Rank | Number | Get or set the value of “n” in a “top/bottom n” conditional formatting rule. If IsPercent is true, the value must betwee |
Top10()
Top10.IsPercent property
Get or set whether a “top/bottom n” rule is a “top/bottom n percent” rule. Default value is false.
Type: boolean
Top10.IsBottom property
Get or set whether a “top/bottom n” rule is a “bottom n” rule. Default value is false.
Type: boolean
Top10.Rank property
Get or set the value of “n” in a “top/bottom n” conditional formatting rule. If IsPercent is true, the value must between 0 and 100. Otherwise it must between 0 and 1000. Default value is 10.
Type: Number