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”
![Data sets to apply the Data bars conditional formatting](https://www.pk-anexcelexpert.com/wp-content/uploads/ConditionalFormatting/Comditinal-Formatting-1.jpg)
- Go to Home tab>>Conditional Formatting>>Data Bars>>Choose a preset
![Data Bars option in Conditional formatting](https://www.pk-anexcelexpert.com/wp-content/uploads/ConditionalFormatting/Conditional-Formatting-23.jpg)
You can choose a design from Gradient Fill option. It will look like below image
![Gradient Fill of data bars](https://www.pk-anexcelexpert.com/wp-content/uploads/ConditionalFormatting/Conditional-Formatting-24.jpg)
You also can choose a design from Solid Fill option. It will look like below image
![Solid Fill option in data bars](https://www.pk-anexcelexpert.com/wp-content/uploads/ConditionalFormatting/Conditional-Formatting-25.jpg)