'Declaration Public NotInheritable Class RankConditionalFormat Inherits ConditionalFormatBase
public sealed class RankConditionalFormat : ConditionalFormatBase
A rank condition evaluates to true if a cell value is within the range defined by the top or bottom n values across the associated range, where n represents the Rank.
A popular example of a rank condition is "top ten ", where cell values which are within the range of the ten highest values across the range meet the condition. The Rank property, however, can be set to any arbitrary number or percentage, and is not limited to only the top or bottom ten values.
By default, this condition evaluates to true if a cell's value is at or above the specified rank; to change this to the bottom of the ranking, set the TopBottom property to 'Bottom'.
The numeric criteria can be changed to a percentage using the IsPercent property. In this case, the Rank property is interepreted as a percentage.
Target Platforms: Windows 8.1, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
View on GitHub