I have 6 variables, they are 1, 2, 3, 4, 5 and 6.
I would like to have a cell have a dropdown menu where the user can select
which of the six variables they want. Depending on which variable is chosen,
that cell and the cell above it will change to a specific color that is
associated with each variable.

Thanks!!!
Dan