I have created a spreadsheet with drop down boxes that rely on one selection
to determine the choices for the next selection. For example, if you select
"Base" or "Upgrade" in the first drop down box(column heading is Option), the
second drop down box will list available color selections for the selected
option. I have protected the worksheet so only these drop down boxes are
accessable. unfortunaly a user can still do the following:

1. Type into the cell any value they choose ignoring the drop down box
2. Select an option and a color selection associated with that option and
then change the option without being required to change the color selection.

How do I limit the cell input to only one of the selections in the drop down
box and how do I restrict the color selections to those availabe to the
selected option?