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

'Usage
 
Dim style As ConditionalFormattingStylePresets
Dim rank As Integer
Dim percent As Boolean
Dim bottom As Boolean
Dim value As ConditionalFormattingTop10
 
value = ConditionalFormatting.CreateTop10(style, rank, percent, bottom)

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

Parameters

style

The ConditionalFormattingStylePreset. 

rank

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

percent

Determines if the Rank value is transformed into a percentage.

bottom

Determines if the bottom tier values are used instead of the top tier ones.

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

ConditionalFormatting Class
ConditionalFormatting Members