A TECHTORIAL

HAPPY FACE/SAD FACE

"J" and "L"? What on earth?!

We need Excel to show a happy face when the answer is right and a sad face when the answer is wrong. Although a happy face is on the Drawing toolbar, that won't work for our purposes. Instead, click in cell D2 and type a capital J. Highlight the J, and then select Wingdings as your font. Tada! You've got a happy face (Wingdings is a font of commonly used symbols).

Before moving on, let's correct the Correct column.

  • Highlight cells C2, C3, and C4.
  • Select Wingdings font.
  • Change the size to 22.
  • Change the color to green -- or any other color you want that shows up. Yellow is not a good choice. And remember, just the outline of the happy/sad face will appear. The face will not be filled in with a color.

If you have a 2 in cell B2, you should now see a happy face in cell C2. If you have anything else in cell B2, you should see a sad face.

Next: Finishing touches.

 

 
Close window