drop-box and numeric values

[tg]

hi there:

i have created a drop-box with the items A, B, and C as
the options. Now I would like to assign a numeric value to
each option as well as a shaded background. Can anyone
guide me on how to do this?

thx, tg

 

[Tom Ogilvy]

what kind of dropdown box. From the forms toolbar, from the control toolbox
toolbar, using data validation.

What do you mean by assign a numeric value.

How did you get the options A, B, C into your drop-box.

Where do you want shading to occur - certainly not in the dropdown - that
isn't supported in any of them.