Formatting Issues

Display a Check Mark for Text in Excel Conditional Formatting

Elise WilliamsElise Williams Nov 20, 2026 869 views

Question details

Display a check mark when an Excel cell contains text such as x or a numeric value such as 1, without using VBA.

Display a Check Mark for Text in Excel Conditional Formatting
Product
Microsoft Excel and Excel for the web
Device & OS
not provided
Scenario
A workbook needs to show check marks for entered values while remaining usable in Excel for the web.
Observed behavior
A custom number format can display a check mark for numeric values, but it does not replace text such as x.
Before you start

Identify the cells containing your input values and choose an empty helper column for the check marks. Check whether the Wingdings font is available, or use the Unicode formula described below.

Solution 1Recommended

Use a helper formula to display check marks

Use a separate column to display check marks for text or numeric values without VBA.

Conditional formatting changes a cell's appearance but does not replace its text with a different character. A helper formula displays the check mark in another cell while preserving the original input.

1
Enter the formula

If the input is in A2, select B2 and enter =IF(A2="x",CHAR(252),""). To check for the number 1 instead, enter =IF(A2=1,CHAR(252),"").

2
Apply Wingdings

Select B2, open the font list on the Home tab, and choose Wingdings. The formula result appears as a check mark when the condition is met.

3
Copy the formula

Drag the fill handle from B2 down the helper column to check the remaining input cells.

Use a helper formula to display check marks
If Wingdings is unavailable: In B2, use =IF(A2="x",UNICHAR(10003),"") for text or =IF(A2=1,UNICHAR(10003),"") for numbers. Choose a standard font that supports the Unicode check mark instead of Wingdings.
Work with check marks in WPS Spreadsheets

Display Check Marks with a Helper Formula in WPS Spreadsheets

Use a helper column and a formula in WPS Spreadsheets to show check marks for text or numeric inputs without VBA.

  1. 1. Open the workbook: Open WPS Spreadsheets and select Open to load your Excel workbook.
  2. 2. Enter a helper formula: Select B2 next to the input in A2 and enter =IF(A2="x",CHAR(252),""). For a numeric input, use =IF(A2=1,CHAR(252),"").
  3. 3. Set the font and fill down: Select B2, choose Wingdings from the Home tab's font list, and drag the fill handle down to apply the formula to other rows.
  4. 4. Save the workbook: Choose File > Save As and save the workbook in Excel XLSX format.
Display a check mark when a cell contains x or 1.Keep the original input separate from the displayed result.Open and save Microsoft Excel XLSX workbooks.Use a familiar spreadsheet interface.
microsoft office alternative - wps office

Frequently Asked Questions

Can conditional formatting replace an x with a check mark?

No. Conditional formatting changes the cell's appearance, not its text. Use a helper cell such as B2 with =IF(A2="x",CHAR(252),"") and apply the Wingdings font.

Will the helper formula work in Excel for the web?

Yes. The IF and CHAR formulas do not require VBA and can be used in Excel for the web. If Wingdings does not display as expected, try =IF(A2="x",UNICHAR(10003),"") with a font that supports the check mark.

How do I show a check mark for the number 1?

Enter =IF(A2=1,CHAR(252),"") in a helper cell and select Wingdings from the Home tab's font list. The result is blank when A2 is not 1.

Why does the formula show a different character instead of a check mark?

CHAR(252) needs the Wingdings font to appear as the intended check mark. Select the formula cell and choose Wingdings, or use UNICHAR(10003) with a font that supports that symbol.