How to apply Conditional Formatting in Excel ? Part-2!

Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify.They are grouped into three categories: Data Bars are horizontal bars added to each cell, much like a bar graph. Color Scales change the color of each cell based on its value. Each color scale uses a two- or three-color gradient.

To add conditional formatting with data bars, follow these steps. On the Excel worksheet, select the cells with numbers that you want to format.