How to Validate Input with a Check Mark in Excel

If you want to confirm an input in Excel with a tick character, you can use a basic formula and fonts like Wingdings 2. This article will give you some tips on doing this and provide examples.

How To Confirm An Input With A Tick Character

What is the usefulness of this?

  • The tick or check mark character is great for managing long lists.
  • The COUNTIF function can be used to count the number of cells within a range that meets a given condition.

In this example, the “IF” and “COUNTIF” functions are used. The COUNTIF function will help us to know if the Name in Cell F8 is within the ACCEPTED Name range that we curated.

Basic formula-   =IF(COUNTIF(I8:I11, F8), "P", "") If the “IF” statement is TRUE, a Capital P shows up. If the “IF” statement is FALSE, a “” shows up.

Step 1

Type your data into the spreadsheet as shown below

Figure 1- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

Step 2

Let us get interested in JOAN. Click on INSERT on the taskbar and then SYMBOL.

Figure 2- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

I have selected this –

Now, click on INSERT and CLOSE. You will have the next figure below.

Figure 3- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

 

Step 3

Now, input the following into the fx bar. =IF(COUNTIF(

Step 4

Highlight the names under the section captioned NAME RANGE as shown in the figure below.

Figure 4- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

Highlight JOAN on Cell F8 or type F8 on the fx bar as shown below.

Figure 5- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

Step 5

Figure 6- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

Close the bracket and what you should have in the fx bar finally should be the basic formula below.

Basic formula-   =IF(COUNTIF(I8:I11, F8), "P", "")

When you hit the ENTER BUTTON, you will have the next figure.

Figure 7- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

Step 6

Can you see the tiny stuff that I circled in figure 7 above, we are going to simply double-click on it and see what happens.

Figure 8- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

 

Now, highlight Cells G8-G11. Click on the Home tab, go to font type and click on WINGDINGS 2.

The selected tick character shows up as seen below.

Figure 9- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Your first session is always free. 

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar