Trying to create a drop down box in excel but don't want text or numbers as
my options -- wanting red, yellow and green filled circles. Can anyone help?
Thank you!

To the best of my knowledge that type of functionallity does not exist.
--
HTH...

Jim Thomlinson


"Secretary" wrote:

Trying to create a drop down box in excel but don't want text or numbers as
my options -- wanting red, yellow and green filled circles. Can anyone help?
Thank you!

Perhaps Wingdings2 font character code 0098, then set font color

Secretary wrote:
Trying to create a drop down box in excel but don't want text or numbers as
my options -- wanting red, yellow and green filled circles. Can anyone help?
Thank you!

I cannot do the colored circles but how about selecting the cell color from
a drop down to produce your red, yellow or green? There is actually a value
in the drop down-colored cell but it is formatted the same as the cell color
for each selection, therefore you don't see it.

If that will work for you I can post some code that lets you do that, along
with some fairly simple instructions. Or send you a workbook.

The circles are beyond me, sorry.

HTH
Regards,
Howard

"Secretary" wrote in message
...
Trying to create a drop down box in excel but don't want text or numbers
as
my options -- wanting red, yellow and green filled circles. Can anyone
help?
Thank you!