Excel.ConditionalTopBottomRule interface
Represents the rule of the top/bottom conditional format.
Remarks
Properties
| 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. |
Property Details
rank
The rank between 1 and 1000 for numeric ranks or 1 and 100 for percent ranks.
rank: number;Property Value
number
Remarks
type
Format values based on the top or bottom rank.
type: Excel.ConditionalTopBottomCriterionType | "Invalid" | "TopItems" | "TopPercent" | "BottomItems" | "BottomPercent";Property Value
Excel.ConditionalTopBottomCriterionType | "Invalid" | "TopItems" | "TopPercent" | "BottomItems" | "BottomPercent"
Remarks
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Add-ins
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for