|
Home > Format > Conditional > Custom Icons Excel Custom Icon Sets - Advanced Settings
|
![]()
In Excel, you can use any of the built-in icon sets for conditional formatting. These icon sets combine colours and shapes, to give a quick visual analysis of the data.
However, if none of the built-in options have exactly what you need:
![]()
In this video, I show how to add an icon set to Excel data, then make quick changes to the icons. The written steps are on the Excel Icons - Get Started page.
When you use the Excel Ribbon commands to apply Conditional Formatting Icon Sets, Excel uses its default settings. In the steps below, see how to:
✅ To follow along, get the Excel sample file in the download section
In the example below, I applied a directional arrow icon set to a list of numbers.
To see the default settings for my list of 10 numbers, I followed the steps below:
![]()
The Conditional Formatting Rules Manager opens, and it shows the rule(s) for the selected cells (Current Selection).
![]()
After you click the button, the Edit Formatting Rule window opens.
![]()
In the "Edit the Rule Description" section, there are two settings that let you make a quick change to the icon sets:
![]()
If you're working with sales data, high numbers are usually good, so a green up arrow is perfect, with a red down arrow for low numbers.
However, if the data is tracking system errors, or machine down time, the opposite is true! High numbers indicate problems, and they should have a red icon.
In the animated gif below, the green and red icons in the lower section are switched, each time I click the button.
![]()
In the Edit Formatting Rule window, the other quick setting is the Show Icon Only check box.
![]()
And here's a screen shot of sample data, with numbers and icons in one column, and icons only in the next column.
![]()
Instead of using one of the built-in icon sets, you can create a custom set, by making either of the following changes:
The detailed steps are in the sections below.
In the screen shot below, there are 3 rows of data, showing 2 years of sales for each of the 3 regions - East, West and Central.
In column F, a formula subtracts the 2024 total from the 2025 total, and returns the difference.
In the Difference column, I used a Directional icon set -- 3 Arrows (Colored).
![]()
Instead of using those default icons, I want a custom icon set, with 2 types of arrows:
To change the number setting for an icon set, follow the usual steps to select the cells, go to the Rule Manager, select a rule, and click the Edit Rule button.
![]()
After you've selected your custom icons, change the Value settings:
Next, make these changes for the Not Cell Icon settings:
When finished, click OK, twice, to close the windows.
![]()
On the worksheet, the custom icons have a red arrow for the number below zero, and green arrows for the numbers above zero.
![]()
By default, the conditional formatting icons are based on each cell's value, relative to range of numbers in the list..
![]()
The percentage for each value is calculated based on the minimum and maximum numbers in the range of cells.
In the screen show above:
The percentage calculation is:
For example, number 6 is 55.6%
To change the number setting for an icon set, you can type numbers into the Value boxes, or link to worksheet cells, like I did in the screen shot below.
![]()
Having the values on the worksheet, makes it easy to change the settings.
You can just type different numbers in cells F4 and F5, to see immediate results!
![]()
Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.
Next, when you get my reply, click the Confirm button. I add this step to protect you from spam!
Conditional Formatting Examples
Conditional Format Color Scales
Fix Conditional Formatting Extra Rules
Conditional Formatting Multiple Cells
Conditional Formatting - Currency
Last updated: May 12, 2026 12:21 PM