AddRankCondition Method

Adds a new RankConditionalFormat instance to this collection.

Syntax

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: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+