Conditional Formatting Icons in Google Sheets

Conditional formatting icons in Google Sheets let you add visual status indicators to your data using formulas and formatting rules. Unlike Excel, Sheets does not have a built-in icon set feature, but you can build the same effect with conditional formatting and a few helper columns. The result: a color-coded dashboard where status is visible at a glance.

We’ll cover how to create icon columns with IF and CHAR(), color them with conditional formatting rules, and build traffic-light emoji indicators using IFS formulas.

In This Guide

• How Icon Sets Work in Google Sheets
• Step-by-Step: Build a Status Icon Column
• Traffic Light Emojis with IFS
• CHAR() vs. Emoji: When to Use Each
• Tips and Best Practices
• Related Google Sheets Tutorials
• FAQ

How Icon Sets Work in Google Sheets

Excel has a built-in icon set feature that drops arrows, traffic lights, or checkmarks into cells based on value thresholds. Google Sheets does not offer this. Instead, you build it yourself in two parts:

1. A formula column that returns a symbol (via CHAR() or direct emoji) based on cell values
2. Conditional formatting rules that color the symbol based on the same values

The formula generates the icon. The formatting controls the color. Together, they replicate what Excel does with one click, except you get more control over which icons appear and how they look.

Sample Data

We’ll use a task tracker with 10 tasks. Columns A through F contain Task, Assigned To, Due Date, Status, Priority, and Complete.

Step-by-Step: Build a Status Icon Column

In cell G1, enter the header Icon. In G2, enter this formula:

=IFS(D2="Complete", CHAR(10004), D2="In Progress", CHAR(9654), D2="Not Started", CHAR(9675), TRUE, CHAR(9888))

This returns a different symbol for each status:

Copy G2 down through G11. Every row now shows a symbol based on its Status value.

Select G2:G11. Go to Format > Conditional formatting. Create four rules, each using Custom formula is:

Rule 1 — Complete (green):

=$D2="Complete"

Set text color to green (#34a853).

Rule 2 — Overdue (red):

=$D2="Overdue"

Set text color to red (#ea4335).

Rule 3 — In Progress (amber):

=$D2="In Progress"

Set text color to dark yellow (#f59e0b).

Rule 4 — Not Started (gray):

=$D2="Not Started"

Set text color to gray (#9ca3af).

The $D2 reference locks to column D so the rule checks the Status column for every row in the icon column. For more on this technique, see formatting based on another cell.

In column H, add a second icon column for Priority. In H2:

=IFS(E2="High", CHAR(9650), E2="Medium", CHAR(9644), TRUE, CHAR(9660))

Apply conditional formatting rules to H2:H11: red text for High (=$E2="High"), amber for Medium, and blue for Low.

Your task tracker now has two icon columns. Each row displays its status and priority at a glance. Colonel Moran’s completed task shows a green checkmark and an amber dash. Mycroft Holmes’s overdue budget submission shows a red warning sign and a red up-arrow.

Traffic Light Emojis with IFS

If you want colored circles without conditional formatting, emoji characters handle both shape and color in one step. Unicode includes colored circle emojis that render consistently across platforms.

In a helper column, enter:

=IFS(F2=TRUE, CHAR(128994), D2="In Progress", CHAR(128993), D2="Overdue", CHAR(128308), TRUE, CHAR(11093))

This approach checks the Complete column (F) first. If F2=TRUE, the task gets a green circle. Otherwise, the formula checks the Status column for In Progress, Overdue, or defaults to a white circle for Not Started.

Combining Approaches

You can use both techniques in the same sheet. CHAR() symbols with conditional formatting give you full control over colors and font size. Emoji circles work as a self-contained traffic light with no formatting rules needed. Pick whichever fits your use case, or use one column for status and the other for priority.

CHAR() vs. Emoji: When to Use Each

Use CHAR() when you need custom formula conditional formatting to control the icon’s appearance. Use emojis when the icon’s built-in color already communicates the meaning.

Tips and Best Practices

1. Keep icon columns narrow. Set column width to 30-40 pixels and center-align the cells. The icons stand out more when they are not surrounded by whitespace.

2. Use data validation for the Status column. A dropdown list prevents typos that break your IFS formula. If someone enters “complete” instead of “Complete,” the formula falls through to the default case. See checkbox data validation for another way to track completion.

3. Freeze the icon columns next to the data. If your sheet scrolls horizontally, freeze the status icon column so it stays visible. Go to View > Freeze and select the appropriate column count.

4. Test CHAR codes before committing. Enter =CHAR(10004) in an empty cell to preview the symbol. Not all Unicode code points render in Google Sheets. Stick to common symbols in the 9000-10000 and 128000-129000 ranges.

Related Google Sheets Tutorials

• Conditional Formatting: Complete Guide — all rule types, color scales, and managing multiple formatting rules
• Custom Formula Conditional Formatting — write your own formatting rules using any Google Sheets function
• Format Based on Another Cell — apply formatting to one column based on values in a different column
• Data Validation Checkboxes — add TRUE/FALSE checkboxes for task completion tracking

Frequently Asked Questions

Does Google Sheets have icon sets like Excel?

No. Google Sheets does not have a built-in icon set feature for conditional formatting. You can replicate the effect by using IF or IFS formulas with CHAR() or emoji characters to generate icons in a helper column, then applying conditional formatting to color them by status.

How do I add emoji icons based on cell values in Google Sheets?

Create a helper column with an IF or IFS formula that returns different emojis based on a condition. For example, =IF(D2="Complete", CHAR(9989), CHAR(10060)) returns a green checkmark for Complete and a red X for other values. You can also paste emoji characters directly into the formula.

Can I change emoji colors with conditional formatting?

Conditional formatting changes cell background and text color, but most emojis are rendered as images by the operating system and ignore text color. CHAR()-based symbols like checkmarks and X marks do respond to text color rules. Use CHAR(10004) for a checkmark and CHAR(10008) for an X if you need color control.

How do I create a traffic light system in Google Sheets?

Use an IFS formula to return colored circle emojis based on thresholds. For example, =IFS(F2>=80, CHAR(128994), F2>=50, CHAR(128993), TRUE, CHAR(128308)) returns a green circle for 80 or above, yellow for 50 to 79, and red below 50.

What is the difference between CHAR() symbols and emoji in Google Sheets?

CHAR() returns Unicode characters that render as plain text. They respond to font color and conditional formatting text color rules. Emojis are graphical characters rendered by the operating system. They appear in color regardless of text formatting. Use CHAR() when you need color control and emojis when you want universally recognizable icons.