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”
Data sets to apply the Data bars conditional formatting
Data sets to apply the Data bars conditional formatting
  • Go to Home tab>>Conditional Formatting>>Data Bars>>Choose a preset
Data Bars option in Conditional formatting
Data Bars option in Conditional formatting

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

Gradient Fill of data bars
Gradient Fill of data bars

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

Solid Fill option in data bars
Solid Fill option in data bars

 

Next ChapterPrevious Chapter