Top and bottom rules
The top and bottom rules allow you to identify values based on their relative positions within a list. Four out of the six reference 10 Items or 10%, but you can enter any number or percentage that you wish. To apply any of these rules, do the following:
- Select a range of cells that you wish to format, such as cells H3:H22, of the Top and Bottom Rules worksheet in this chapter’s example workbook.
- Choose Home | Conditional Formatting | Top/Bottom Rules and then select a rule:
- Top 10 Items: Formats the 10 largest values in the list unless you specify a different value
- Top 10%: Formats 10% of the largest values in the list unless you specify a different value
Nuance
The percentage is based on the number of items on your list. If your list has 90 items and you specify Top 10%, the Conditional Formatting feature will multiply 90 by 10 to determine that the 9 largest values should be formatted.
