The easiest way to do this is with the IF function and the mark you would like to display.
The article below explains several options.
Notice the checkmark itself must be enclosed in double quotes ("") since it is text.
The benefit of this approach is that you might easily change the number to display a different character.
If you skip this step, you will not see a checkmark.
Instead, you will see a character like “u” or similar.
Visitthis pagefor a comprehensive guide on conditional formatting with formulas, featuring many practical examples.
More than one condition can be tested by nesting IF functions.
CHAR can insert characters that are hard to enter into a formula.
Related videos
The IF function
How to insert symbols and special characters in Excel
