Conditional formatting in Excel--Top/bottom Rules

January 14, 2022
53 Views 0

Graphic skills

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


In this tutorial, we are going to talk about Top/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.

Conditional formatting in Excel1.png 

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?