Is there a way to create a list in excel with smilies instead of .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a list in excel where my drop down items will be
smileys or symbols of various colors instead of text. Is that possible?
 
Hi CFE,

If your font is set as Arial or Times New Roman or quite a few others,
Hold down the Alt key and type 1 on the number pad and let go of the Alt key
Alt+2 is another variation.

There is also lots of others in Wingdings and Webdings etc. To access these
go to Start>Programs>Accessories>System Tools>Character Map
There isn't any shortcut keys to get most of these symbols, but once you
have
the ones you need, you can copy and paste them to where you want.

HTH
Martin
 
OK, may be I did not make myself clear. I have no problem getting the
symbols but what I am unable to do is: when in an excel cell and I create a
list of items to chose from, I want those items to be symbols to chose from
and I also need to be able to have those in color. i.e. if I have a red
smiley for task in danger, green for task on target, yellow for task in
jeopardy and grey task not initiated but my boss wants smileys and there is a
smile symbol in the library. How do I get my drop down to show those
smileys. I know it sounds weird but just trying to do what I am being asked.
Thanks
 
I've used this technique with some success:
The following three letters, formatted as Windings style font, may give you
some ideas:
J = happy face
K = no feelings
L = sad face

You could do something like: =IF(A1>90,"J",IF(A1<60,"L","K"))

Hope that helps,
Ryan---
 
Back
Top