AddRankCondition Method

Adds a new RankConditionalFormat instance to this collection.

Syntax

Visual Basic

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

C#

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

The resulting RankConditionalFormat instance.

Remarks

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.

Requirements

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