A
Alex
I want to be able to allow an option on a drop down list only if another cell
has a particular value.
What I am trying to do is I have a list of people with their title
(Mr,Ms,Mrs,Miss) and I also have Gender (Male,Female). Both of these a
dropdown lists. I would like when Ms,Mrs or Miss is selected, it only allows
an entry of Female to gender, and if Mr is selected it only allows Male for
Gender.
Is there any way to do this?
Cheers
has a particular value.
What I am trying to do is I have a list of people with their title
(Mr,Ms,Mrs,Miss) and I also have Gender (Male,Female). Both of these a
dropdown lists. I would like when Ms,Mrs or Miss is selected, it only allows
an entry of Female to gender, and if Mr is selected it only allows Male for
Gender.
Is there any way to do this?
Cheers