Printable View
i have created a list Yes/No using Data validation . Now tell me how to do this -
If i select "Yes" then nothing but if "No" then it shud give me an error msg.
Also another instance where if i select Yes then the next row will hide.
Pls if someone can help me
Change the DV to only Yes and it will give the error message.
Thanks for the help, but i want both the option and if a user select No then it shud throw an error
If you are going to throw an error, what is the rationale for even havng that as an option?
Pick A or B! Oh, you picked B, that is not allowed. It does not compute Jim!