Smiley Face
Posted by Mark McGrath on February 07, 2002 1:08 AM
I want to be able to display in Excel a smiley face depending on performance (e.g. Good performance=Happy Face, Poor performance=Sad Face). I know that the 2 smiley face images are available with characters J & L using the Wingdings font, but to be consistent with other methods of input I want the users to type in 1 for Good and 2 for Poor, rather than J and L.
Is there any way, maybe with a user-defined font, of typing in 1 & 2 and being able to return J & L in the same cell to give me the smiley face image without using a macro.
Posted by Whitestar on February 07, 2002 4:33 AM
You can do this by using an IF statement.
Say you want to insert 1 or 2 into a cell in column A and the have the smiley returned in column B. What you do is, in the cell in column B type; =IF(A1=1,"J",IF(A1=2,"L"<)). Now select all the cells where you want the smiley returned and change the font to wingdings 1. Note that the J and L in the statement must be in capitlals.
Hope this has helped.
Posted by Mark W. on February 07, 2002 7:14 AM
Use Conditional Formatting [nt]
