Conditional formatting in Excel—Data Bars

January 4, 2022

A free Office suite fully compatible with Microsoft Office

Free Download

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.

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.

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.

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