ConditionalFormatRuleSetTopOrBottomRanked Method

Sets a 'Top or Bottom Ranked' formatting condition to this conditional formatting rule.

Namespace: GemBox.Spreadsheet.ConditionalFormatting
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 45.0.35.1000

Syntax

public TopOrBottomRankedCondition SetTopOrBottomRanked(
	bool bottom,
	int rank
)

Public Function SetTopOrBottomRanked ( 
	bottom As Boolean,
	rank As Integer
) As TopOrBottomRankedCondition

bottom: Type: SystemBoolean
if set to format cells with bottom ranked values; otherwise, format cells with top ranked values.
rank: Type: SystemInt32
The number of top or bottom ranked cells which are formatted.

Type: TopOrBottomRankedCondition
A TopOrBottomRankedCondition set to this conditional formatting rule which can be used to further customize the formatting condition.

Exceptions

Exception	Condition
ArgumentOutOfRangeException	Parameter rank is less than or equal to zero.

ConditionalFormatRuleAddLanguageSpecificTextSet("LSTA6648F1C_0?cpp=::|nu=.");SetTopOrBottomRanked Method