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