Home > Format > Conditional > Custom Icons

Excel Custom Icon Sets - Advanced Settings

Debra Dalgleish - Contextures

Create Excel custom icon sets for conditional formatting, instead of using the default choices! Pick different icons or no icons. Change the number setting for high/low icons, and see how the percentage settings work.

custom icons up or down only

1.0) Conditional Formatting Icon Sets

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:

  • You can modify an icon set
  • Or, build a custom Excel icon set to suit your data.

conditional formatting built-in icon sets menu

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.

2.0) Modify Icon Settings

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:

  • Check the current icon settings
  • Make quick changes to the settings.

✅  To follow along, get the Excel sample file in the download section

2.1) Check Current Icon Settings

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:

  • Select the cells with the icon set - cells B2:B11 in this example
  • Next, on the Excel Ribbon's Home tab, click Conditional Formatting
  • At the bottom of the drop-down list, click on Manage Rules

click on Manage Rules

2.2) Conditional Formatting Rules Manager

The Conditional Formatting Rules Manager opens, and it shows the rule(s) for the selected cells (Current Selection).

  • If there are multiple rules in the list, click on the rule that you want to change.
  • Next, click the Edit Rule button, to open the Edit Formatting Rule window.

Conditional Formatting Rules Manager

2.3) Edit Formatting Rule

After you click the button, the Edit Formatting Rule window opens.

  • At the top, "Format all cells based on their values" is selected.
  • Don't change that setting.

Edit Formatting Rule window

In the "Edit the Rule Description" section, there are two settings that let you make a quick change to the icon sets:

  • A) Reverse Icon Order
  • B) Show Icon Only

Edit the Rule Description

2.3 A) Reverse Icon Order

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.

Use the Reverse Icon Order Button
  • To change the icon order, click the Reverse Icon Order button
    • Later, to return the icons to their original order, click the button again,
  • When the icons are in the order that you need, click the OK button, to close the Edit Formatting Rule window.

In the animated gif below, the green and red icons in the lower section are switched, each time I click the button.

click the Reverse Icon Order button to change icon

2.3 B) Show Icon Only

In the Edit Formatting Rule window, the other quick setting is the Show Icon Only check box.

  • ❌ To see both the numbers and the icons, leave the check box empty
  • ✔️ To hide the numbers, and see only the icons, add a check mark

Show Icon Only

And here's a screen shot of sample data, with numbers and icons in one column, and icons only in the next column.

  • Tip: You could leave the numbers in one column, and put the icons in a column to the right.

numbers and icons, and icons only

3.0) Customize an Icon Set

Instead of using one of the built-in icon sets, you can create a custom set, by making either of the following changes:

  1. Select Different (or No) Icons
  2. Change Number/Percent Settings

The detailed steps are in the sections below.

3.1) Select Different Icons

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).

  • Lowest number shows a red down arrow
  • Middle number shows a yellow sideways arrow
  • Highest number shows a green up arrows.

default icons 3Arrows (colored)

3.3.1) Plan the Icon Change

Instead of using those default icons, I want a custom icon set, with 2 types of arrows:

  • For numbers greater than zero - green up arrows
  • For numbers less than zero - red down arrows
  • For zero values - no icon

3.3.2) Edit the Ixons

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.

  • First, to remove the yellow arrow, click on the drop down arrow
  • At the top of the list, click on No Cell Icon

click on No Cell Icon

3.2) Change the Numbers

After you've selected your custom icons, change the Value settings:

  • For the green arrow, choose > (greater than), from the operator drop down
  • In the Value box, type a zero
  • From the Type drop down, choose Number

Next, make these changes for the Not Cell Icon settings:

  • Choose >= (greater than or equal to), from the operator drop down
  • In the Value box, type a zero
  • From the Type drop down, choose Number

When finished, click OK, twice, to close the windows.

change number settings for custom icon set

3.2.1) Numbers with Custom Icons

On the worksheet, the custom icons have a red arrow for the number below zero, and green arrows for the numbers above zero.

custom icon set up or down only

3.3) Percent Setting Calculation

By default, the conditional formatting icons are based on each cell's value, relative to range of numbers in the list..

  • Numbers in top 1/3 of values (67% or higher) have green triangle, pointing up.
  • Numbers in bottom 1/3 of values (33% or lower) have red triangle, pointing down
  • Numbers in middle 1/3 of values (>33% and <67%) have horizontal yellow bar

default percentage settings

3.3.1) Percentage Calculation

The percentage for each value is calculated based on the minimum and maximum numbers in the range of cells.

In the screen show above:

  • Maximum number is 10
  • Minimum number is 1

The percentage calculation is:

  • (Value - Min) / (Max - Min)

For example, number 6 is 55.6%

  • =(6-1)/(10-1)

3.4) Worksheet Values

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.

custom icon set with links to worksheet values

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!

  • For example, change the high number to 80, and only 2 numbers have a green circle.
  • Change the middle number to 40, and 4 numbers have a red circle.

custom icon set with worksheet values

4.0) Get the Excel Files ✅

  1. Custom Icon Sets: Get the Custom icon set examples file. The zipped Excel file is in xlsx format, and does not contain any macros.

Get Monthly Excel Tips!

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!

More Tutorials

Conditional Formatting Intro

Conditional Formatting Examples

Conditional Format Color Scales

Fix Conditional Formatting Extra Rules

Conditional Formatting Multiple Cells

Conditional Formatting - Currency

Conditional Formatting Documentation

Conditional Formatting Data Bars

Last updated: May 12, 2026 12:21 PM