Question regarding using pull down menus inside an Excel workbook.
 

I've got the pull-down menus option pretty well figured out. The problem is
that instead of a pull-down list of text options, I want the pull-down
options to be color coded - Red, Yellow and Green. I also want to use three
versions of each color with a symbols being the differentiator. (up arrow,
down arrow, no arrow.)

But when I try to set up the pulldown menu the color doesn't come through
and instead of the symbol I'm getting that odd text version of the symbol
instead of the up or down arrow.

Any advice or suggestions on how I can get the color coded pull-down menu to
work would be appreciated.