Microsoft Office Tutorials and References
In Depth Information
Highlight the Top or Bottom Values in a Range
Chapter 5: Analyzing Excel Data
8 Click OK.
Excel applies the
formatting to cells that
meet the condition you
Excel also enables you to create top/bottom
rules based on the average value in the
range. First, follow steps 1 to 4 to select the
range and display the Top/Bottom Rules
menu. Then click either Above Average to
format those values that exceed the range
average, or Below Average to format those
values that are less than the range average.
If you no longer require a top/bottom
rule, you can delete it. Follow steps 1 to
3 to select the range and display the
Conditional Formatting drop-down
menu. Click Clear Rules, and then click
Clear Rules from Selected Cells. Excel
removes the rule from the range.