If you have not got a change to read that article, you may want to do this know. Last week we started to explorer various features and capabilities of Conditional formatting in Excel 2016, 20. It will teach you how to extend these conditional formats beyond their common uses and apply icons based on another cell's value. The article provides the detailed guidance on how use conditional formatting Icon Sets, Data Bars and Color Scales in Excel 2019, 2016, 2013, and 2010.