Check Mark in a cell
 

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.

Check Mark in a cell
 

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 FormatConditional Formattingleave 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

"Wally" wrote in message
...
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.