FormatConditions.AddTop10 Method
Definition
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 ObjectReturns
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.