The warning sign ⚠ is Unicode U+26A0, decimal 9888. In Excel you can paste it, make it with a formula, or get a colored warning icon from conditional formatting. It has two looks: a plain text sign ⚠ that takes the cell’s font color, and a yellow emoji ⚠️.
Quick answer
| You want | Fastest method |
|---|---|
| ⚠ in a cell | =UNICHAR(9888), or paste ⚠ |
| ⚠ only when something is wrong | =IF(C2>100,UNICHAR(9888)&” Over limit”,“”) |
| A yellow icon that follows the values | Home → Conditional Formatting → Icon Sets |
| A warning picture on the sheet | Insert → Icons, search “warning” |
| Yellow emoji ⚠️ | Win + . (Windows) or Control + Command + Space (Mac), search “warning” |
| Copy | click ⚠ or ⚠️ at the top of this page |
Method 1: Put ⚠ in a cell
With a formula
- Click the cell.
- Type
=UNICHAR(9888)and press Enter.
UNICHAR is in Excel 2013 and later, on Windows and Mac. To join it to text, use =UNICHAR(9888)&" Check".
Paste or type it
Copy ⚠ from the top of this page and paste it into the cell or the formula bar. On Windows, Win + . opens the emoji and symbol panel; on a Mac, Control + Command + Space opens the Character Viewer. There is no Alt code for ⚠ that works in Excel, and Alt+X only works in Word and Outlook.
Insert Symbol (Windows)
Go to Insert → Symbol, set the font to Segoe UI Symbol, type 26A0 in Character code with from set to Unicode (hex), and click Insert.
Method 2: Flag problem rows with IF
Put the formula in a status column so the sign appears only when it is needed:
=IF(C2>D2,UNICHAR(9888)&" Over budget","")shows ⚠ Over budget when spending passes the budget.=IF(ISBLANK(B2),UNICHAR(9888)&" Missing","")flags an empty required cell.=IF(E2<TODAY(),UNICHAR(9888)&" Overdue","")flags a past due date.
Make the sign red or orange with the cell’s font color, or with a conditional formatting rule (Highlight Cells Rules → Text that Contains, type ⚠).
Method 3: Warning icons with conditional formatting
Icon sets draw a colored icon in the cell based on its value.
- Select the cells.
- Go to Home → Conditional Formatting → Icon Sets.
- Under Shapes, 3 Signs has a yellow triangle. Under Indicators, 3 Symbols (Uncircled) and 3 Symbols (Circled) have a yellow exclamation mark between a green tick and a red X.
To show a warning only on cells that need attention:
- Go to Conditional Formatting → Manage Rules, select the rule and click Edit Rule.
- Set each threshold with Type set to Number, for example the warning for values above 100.
- Change the icons you do not want to No Cell Icon.
- Tick Show Icon Only to hide the numbers, if you like. Click OK.
An icon set is formatting, not a character, so it does not copy into other apps as text and cannot be used in formulas.
Method 4: A warning picture on the sheet
If you searched for a warning symbol to download for a sheet, you probably want an image above the cells, and Excel has one built in:
- Go to Insert → Icons (in some versions Insert → Illustrations → Icons).
- Search “warning” and pick a triangle.
- Click Insert, then resize it and change its color on the Graphics Format tab.
Icons are vector, so they stay sharp at any size and print cleanly. They float over the grid, so they do not move with sorting or filtering.
Text sign or emoji?
- ⚠ (text): what UNICHAR(9888) and Insert Symbol give. It takes the font color and size and prints reliably.
- ⚠️ (emoji): the same character followed by the invisible variation selector U+FE0F, which asks for the yellow emoji design. The Win + . panel and the Mac emoji picker insert this version.
=UNICHAR(9888)&UNICHAR(65039)builds it in a formula.
Whether Excel draws the emoji in color depends on the version and the cell font, so for printed sheets and anything that must look the same everywhere, use the text sign and color it yourself.
Troubleshooting
- The cell shows a box. The font lacks the glyph. Change the cell font to Segoe UI Symbol (Windows) or Apple Symbols (Mac).
- UNICHAR gives #NAME? The version is older than Excel 2013. Paste the symbol instead.
- The icon set shows the wrong icon. It still uses the default percent thresholds. Edit the rule and switch the Type to Number.
- The sign is yellow and I wanted black. You inserted the emoji version. Replace it with
=UNICHAR(9888)or the plain ⚠.
For Word, PowerPoint and Google Docs, see the warning symbol in Word guide. Related signs such as ⛔ ☢ ⚡ are in the warning symbols list, and the warning symbol page has every code.
Frequently asked questions
How do I insert a warning triangle symbol in Excel? +
Click the cell and type =UNICHAR(9888), or paste ⚠ from this page. On Windows you can also press Win + . and search "warning". Excel has no Alt code or Alt+X shortcut for it.
Where can I download a warning symbol for an Excel sheet? +
You do not need to download one. In Microsoft 365, go to Insert → Icons (or Insert → Illustrations → Icons) and search "warning" for a free vector triangle you can recolor and resize. For a symbol inside a cell, paste ⚠ or use =UNICHAR(9888).
How do I show a warning icon only when a value is wrong? +
Use a formula such as =IF(C2>100,UNICHAR(9888)&" Over limit","") in a helper column, or a conditional formatting icon set with the other icons set to No Cell Icon so only the warning appears.
What is the small green triangle in the corner of a cell? +
That is Excel's error checking, not a symbol. Click the cell and the warning button next to it explains the issue, such as a number stored as text. You can turn it off under File → Options → Formulas → Enable background error checking.