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.