Version

RankConditionalFormat Class

Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether a cell's value is within the top or bottom rank of values across the associated range.
Syntax
public sealed class RankConditionalFormat : ConditionalFormatBase 
Remarks

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.

Requirements

Target Platforms: Android 4.4+, iOS 8+

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

See Also