The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

FormatConditions.AddTop10 Method

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

Version Information
 Version Added:  Excel 2007



expression   A variable that represents a FormatConditions object.

Return Value
Top10 object


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.

Community Additions