Data bars, color scales, and icon sets are conditional formats that create visual effects in your data. These conditional formats make it easier to compare the values of a range of cells at the same time.

The article provides the detailed guidance on how use conditional formatting Icon Sets, Data Bars and Color Scales in Excel 2016, 2013, 2010 and 2007. It will teach you how to extend these conditional formats beyond their common uses and apply icons based

The Excel Conditional Formatting Data Bars, Color Scales and Icon Sets allow you to apply formatting to all cells in a range, depending on their value in relation to one another. Note that these options are only applied to cells containing numeric values.