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

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

Thanks

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

What "list options" are you referring to?
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"MarilynP" wrote:

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

Thanks

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

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

On Thu, 8 Mar 2007 11:22:40 -0800, MarilynP
wrote:

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

Thanks