Adds a 'Top or Bottom Ranked' conditional formatting rule applied to a specified sequence of references to cell ranges.
GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 220.127.116.116
public TopOrBottomRankedCondition AddTopOrBottomRanked(
Public Function AddTopOrBottomRanked (
appliesTo As String,
bottom As Boolean,
rank As Integer
) As TopOrBottomRankedCondition
- Type: SystemString
The sequence of references to cell ranges over which the newly added conditional formatting rule is applied.
- Type: SystemBoolean
if set to format cells with bottom ranked values; otherwise, format cells with top ranked values.
- Type: SystemInt32
The number of top or bottom ranked cells which are formatted.
set to a newly created conditional formatting rule which can be used to further customize the formatting condition.
Newly added rule is inserted at the beginning of the collection so it has the highest priority and is first applied.