FormatConditions.AddTop10 Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns a Top10 object representing a conditional formatting rule for the specified range.

public:
 System::Object ^ AddTop10();

public object AddTop10 ();

Public Function AddTop10 () As Object

Returns

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.

Applies to