combo box

L

littleme

Once a word is chosen from the combo
box, I need it to stay... So in H4 it should be able to choose Green,
and in H7 Blue, as it is now, both say whatever I chose last. Second
problem is that the word should only appear in specific cells, rather
than the entire column. Cells should be bland until a colour from the
combo is chosen, and fills in that specific cell, because they are
mean to work as headers. Underneath Blue, they should be able to type,
blueberry, eggplant...etc And then sometimes they may change their
mind, and where it once said eggplant, they want a header Red from the
combo... Do you get what i mean?
 
Top