Microsoft Office Tutorials and References
In Depth Information
Highlight the Top or Bottom Values in a Range
Highlight the Top or Bottom
Values in a Range
To quickly and easily view the extreme values
in a range, you can apply a conditional format
to the top or bottom values of that range.
When you are analyzing worksheet data, it is
often useful to look for items that stand out
from the norm. For example, you might want
to know which sales reps sold the most last
year, or which departments had the lowest
Excel enables you to perform these kinds of
analyses by setting up top/bottom rules, where
Excel applies a conditional format to those
items in a range that are at the top or bottom
of that range of values.
For the top or bottom values, you can specify a
number, such as the top 5 or 10, or a
percentage, such as the bottom 20 percent.
When you set up your top/bottom rule, you
can specify the font, border, and background
pattern, which helps to ensure that the cells
that meet your criteria stand out from the
other cells in the range.
1 Select the range you
want to work with.
2 Click the Home tab.
3 Click Conditional
4 Click Top/Bottom Rules.
5 Click the type of rule you
want to create.
A dialog box appears,
whose name depends on
the type of rule you
clicked in step 5.
6 Type the value you want
to use for the condition.
7 Click here and then click
the formatting you want
To create your own
format, click Custom