Conditional formatting in Excel—Data Bars

January 4, 2022
137 Views 0

Graphic skills

We can use conditional formatting to mark specific contents quickly. Here we take a sales table as an example.

 

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

We are going to talk about Data Bars.

Conditional formatting in Excel1.png  

1. Select the cell range for which you want to set rules. Click Data Bars and select one of them according to your needs. Then the cells are marked with bars of different lengths, from which we can easily know the rank of sales.

Conditional formatting in Excel--Data Bars2.gif  

2. If we need more rules, we can click More Rules to customize a rule. In the pop-up dialog, we can set more details for it. Select a Rule Type first, and then Edit the Rule Description.

Here we show it briefly.

Conditional formatting in Excel--Data Bars3.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?