Abdul Alim: a little bit learning, let's go

Excel, VBA and Power BI tutorials 

Chapter – 3: Data Bars

Data Bars option in conditional formatting makes very easy to read the value in excel cells. A big Bar means big value in the cells.

Below are the steps to apply the data bar conditional formatting in an excel range-

• Select the range on which you want to apply the data bars conditional formatting

• As in below image select “B2:G9”

• Go to Home tab>>Conditional Formatting>>Data Bars>>Choose a preset

You can choose a design from Gradient Fill option. It will look like below image

You also can choose a design from Solid Fill option. It will look like below image