Suppose, you have a list of products that includes units in stock, delivery and other details. Apply an icon set based on other cells in a row (blanks vs. With just a little creativity, you can assign icons depending on the values of other cells in a row or based on another cell's value, as demonstrated in the following examples.
#HOW TO ADD UP AND DOWN ARROWS IN EXCEL HOW TO#
How to apply an Excel icon set based on other cells' valuesĪ common opinion is that Excel conditional formatting icon sets can only be used to format cells based on their own values.
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.