How to Use Data Bars, Color Scales, Icon Sets Conditional Formatting in Excel – Tutorial

We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)

Excel tutorial on how to use Data Bars, Data Scales and Icon Sets options of Conditional Formatting in Excel.

Using these Conditional Format options to format data can help you create a more visually interesting way to show the data and, because the coloring is based on the value of the cell, it can also help you spot trends.