Use Data Bars to Highlight Data Quickly

Data bars in Excel are very useful to visualize values in a range of cells. A longer bar represents a higher value.

To add data bars, follow below steps.

1. Select a range.

2. From the Home tab, click Conditional Formatting, select Data Bars, and than select Gradient or Solid Fill.

Sample Results:

There are different options available under formatting rule options where you can even get rid of numbers and show only the bars.

#DataBars