AddRankCondition Method

'Declaration
 
Public Function AddRankCondition( _
   ByVal regionAddress As String, _
   Optional ByVal topBottom As FormatConditionTopBottom, _
   Optional ByVal rank As Integer _
) As RankConditionalFormat

public RankConditionalFormat AddRankCondition( 
   string regionAddress,
   FormatConditionTopBottom topBottom,
   int rank
)

Parameters

regionAddress

A string identifying the region to which this conditional format applies.

topBottom

A FormatConditionTopBottom value which determines whether the top or bottom of the ranking is evaluated. This parameter is optional and defaults to Top.

rank

The numeric, percentage, or percentile ranking. This parameter is optional and defaults to 10.

Return Value

A RankConditionalFormat can be used, for example, to format the "top ten" values in a given cell range.

To change the number of top or bottom values, use the Rank property.

Target Platforms: Windows 10, 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

Reference

ConditionalFormatCollection Class
ConditionalFormatCollection Members
RankConditionalFormat Class