Hi
In a cell I need a conditional formula(?) based on the value of another cell.
If another cell = "yes" then I want it to require user to choose one of the values from a list
If another cell = "no" then I need just to enter text 'N/A' and no offer any list
How can I do this?
It's probably not too complex.
Many thanks
In a cell I need a conditional formula(?) based on the value of another cell.
If another cell = "yes" then I want it to require user to choose one of the values from a list
If another cell = "no" then I need just to enter text 'N/A' and no offer any list
How can I do this?
It's probably not too complex.
Many thanks