Edit

Share via


FormatConditions.AddTop10 Method

Definition

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

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