Enter this formula in to B1 and format the cell with the wingdings font.

=IF(A1=1,"J","L")

If you enter a 1 in cell A1 you should get your smiley face.

Hopefully you can apply this to your test.

Cheers
Andy

praveen_khm wrote:
Sorry All,

With all the above suggestions, I could not get the resolution for my
question. I ll let you know the reason. I am creating a test and when
someone enters a right answer, I need a happy smiley and sad if wrong.
For happy smiley, I can as well go to the cell and press ALT+1 which
gives a happy smiley. Now what do I do for a sad one? Changing the
format of the cell is no meaning as it makes the work cumbersome.

Please help.
Thanks,
Praveen



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info