FormatConditions.AddTop10 Method
Returns a Top10 object representing a conditional formatting rule for the specified range.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function AddTop10 As Object
'Usage
Dim instance As FormatConditions
Dim returnValue As Object
returnValue = instance.AddTop10()
Object AddTop10()
Return Value
Type: System.Object
Top10 object
Remarks
Using the Top10 object, you can find the highest and lowest values in a range of cells based on a cutoff value that you specify. For example, you can find the top five selling products in a regional report, the bottom 15 percent of products in a customer survey, or the top 25 salaries in a department personnel analysis.