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 *