G Guest Mar 8, 2007 #1 I want assign importance to each list option when selected by colour. Is there anyway to do this? Thanks
I want assign importance to each list option when selected by colour. Is there anyway to do this? Thanks
G Gord Dibben Mar 8, 2007 #3 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
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