how do I display list options as different colour when selected?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MarilynP - 08 Mar 2007 19:22 GMT

I want assign importance to each list option when selected by colour. Is
there anyway to do this?

Thanks

Reply to this Message

Dave F - 08 Mar 2007 20:38 GMT

What "list options" are you referring to?

Signature

A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

> I want assign importance to each list option when selected by colour. Is
> there anyway to do this?
>
> Thanks

Reply to this Message

Gord Dibben - 08 Mar 2007 22:06 GMT

Not sure what you mean by "list option".

Do you mean some cells are blue or green or yellow or.......?

Do you want to assign a ranking number to each color?

Blue cells are 1........green cells are 2 etc.?

How did the cells get their color?

Manually or by Conditional Formatting?

Gord Dibben MS Excel MVP

>I want assign importance to each list option when selected by colour. Is
>there anyway to do this?
>
>Thanks

Reply to this Message