drop down help

I am trying to make an excel doc with multiple drop down options and the following requirements / restriction.

Fist I need the two options available to be distinguishable by colour in the drop down option and once selected.

Then I need the drop down options locked / disabled until the option before has need selected i.e.


So Option B and C are suppose to be unavailable until A is selected and option D is only available once A and either B or C has been selected.

 

Anny assistance and advice will be greatly appreciated.

 

 

By: Logan

Leave a Reply

Your email address will not be published. Required fields are marked *