Im constructing an excel sheet and I need to bind the content of one column
to another so as I change the content of a cell in the first column the
equivalent assigned value appear in the second column automatically. In
addition to that I want to assign color to each stage (see below) so it would
change automatically as I change it. I have 10 items each has an assigned
percentage.

Stage Probability
SP 10
QP 20
DI 30
EV 40
SL 80
PO 100
C 0
L 0
D (A) 100
RnP (B) 100

I want to change the stage and automatically the color and percentage change.
How do I do that?

A second question is it possible to create a drag drop menu for a column or
have some embedded list. I already know how to make a list but not a drag
drop menu from which I can choose the stage.

Thank you,
Esraa El-Sobky