Conditional formatting in Excel--Top/bottom Rules

January 14, 2022

A free Office suite fully compatible with Microsoft Office

Free Download

We can use conditional formatting to mark specific contentsquickly according to a certain rule.

In this tutorial, we are going to talk aboutTop/Bottom Rules. There are multiple rules for selection, namely, Top 10 Items, Top 10%, Bottom 10 Items, Bottom 10%, Above Average and Below Average.

We take Above Average as an example.

Here is a sales table of different branches. Now we want to highlight the data that is above average. Here are the steps.

Open your Excel document, and click the Conditional Formatting drop-down button in the Home tab to get a menu.

1. Select the cell range for which you want to set rules. Click Top/Bottom Rules and select one of the rules here. Here we select Above Average.

Conditional formatting in Excel--Topbottom1.gif

2. In the pop-up dialog, select the format for the cells that are above average from the drop-down list. If we need more formats, click Custom format and set it as needed.

Conditional formatting in Excel--Topbottom2.gif

3. If we need more rules, click More Rules to customize by ourselves.  In the pop-up dialog, we can set more details for it.

Select a Rule Type first, and then Edit the Rule DescriptionHere we show it briefly.

Conditional formatting in Excel--Topbottom3.gif

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.

Was this helpful?