'Declaration
 
Public Function New( _
   Optional ByVal style As ConditionalFormattingStylePresets, _
   Optional ByVal rank As Integer, _
   Optional ByVal percent As Boolean, _
   Optional ByVal bottom As Boolean _
)

'Usage
 
Dim style As ConditionalFormattingStylePresets
Dim rank As Integer
Dim percent As Boolean
Dim bottom As Boolean
 
Dim instance As New ConditionalFormattingTop10(style, rank, percent, bottom)

public ConditionalFormattingTop10( 
   ConditionalFormattingStylePresets style,
   int rank,
   bool percent,
   bool bottom
)

Parameters

style

The ConditionalFormattingStylePresets that will be used to format the Cells.

rank

The number of Cells that will be formatted; in other words, the number of top tier values taken into acount by the ConditionalFormattingTop10.

percent

When set to true, the rank parameter will be interpreted as a percentage.

The default value is false.

bottom

When set to true, the bottom tier values will be taken into account instead; in other words, the ranking will be reversed.

The default value is false.

Target Platforms: Windows 11, Windows 10, 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

Reference

ConditionalFormattingTop10 Class
ConditionalFormattingTop10 Members