Change conditional formatting icon set Actually, there is no way that can change the conditional formatting icon set, but I can introduce a way to insert some similar icons with different colors as you need 1 Select a blank cell beside the data list, for instance, F2, type 67%, then in the below cells, type 33% and 0% See screenshot 2Excel Icon Sets Icon Sets in excel are part of conditional formatting graphics available for numerical data sets By adding these icon graphics, we can design the numbers more beautifully Types of Icon Sets in Excel We can see 4 types of "Icon Sets" available under this category Type#1 – DirectionalTo add Icons with conditional formatting use the AddIconSetCondition method of the FormatConditions object With the IconSet property you can then specify which icon set to use – see the table of VBA constants below You specify criteria for each traffic light as you would in Excel (see image below) using the IconCriteria property For this
Excel Custom Number Formatting How To Conditionally Format Text Fields With Icon Sets Using Number Formatting
Excel icon sets without text