Check Mark in a cell

[Wally]

I would like to have a check mark (or Word Art graphic) appear in a cell when
a value such as 1or x is entered in that cell (or similarly formatted cells).

It would be great if i red 'X' if a wrong value is entered and a green check
mark if a correct value is entered.

 

[John]

Hi Wally
I'm not sure if this is what you want but anyway:
First format with the font Marlett all the cells you want to have X or check
marks,
then type this in those cells
=IF(C12="yes",CHAR(97),IF(C12="no",CHAR(114)))
Change C12 for the cell that hold the answer. change "yes" for the proper
answer
and change "no" for the wrong answer.
Now go to > Format>Conditional Formatting>leave> Cell Value is>
next box choose > Equal to > third box type : =CHAR(114) then press format
and the tab Font change colour to red.
Press the botton ADD>> same has above and third box type =Char(97) press
format botton > Font and choose green.
Hope that will work for you
John