Peak Seagull
Member
Hi,
Hoping someone can help.
In the attached spreadsheet I would like to always return “No” in column C if the answer in column B is also “No”.
As data validation has been applied to column C it doesn’t seem to like applying a formula to achieve the above result.
I can’t remove the data validation because if someone chooses “Yes” in column B then they still have the option to choose “Yes” or “No” in column C.
Hope this makes sense!!
Thank you for your help.
Hoping someone can help.
In the attached spreadsheet I would like to always return “No” in column C if the answer in column B is also “No”.
As data validation has been applied to column C it doesn’t seem to like applying a formula to achieve the above result.
I can’t remove the data validation because if someone chooses “Yes” in column B then they still have the option to choose “Yes” or “No” in column C.
Hope this makes sense!!
Thank you for your help.