Data Validation If Statement

Hello,

I am having difficulties with creating a code or data validation on an if then statement. Currently in C1 I has a list that gives the options "Yes" or "No" and in cells D1, E1, F1 I have manual inputs that feed to a future formula. I would like it so that If C1 = "No" then D1, E1, F1 all equal 0 and if C1 = "Yes" then it just allows for manual input/ or just does nothing. Please let me know if you can help.

Thanks!

Thank you! That works great what would I change it to if I wanted it to skip over cells D1,E1,F1 have no effect in those and only have it change G1,H1,I1,J1 & K1?

Great thank you! I just have two more questions, sorry this model is getting to be more complext than imagined.

I am trying to copy and paste that code and change it to do the same thing for line C2 and further down however it is not working. Do you know what I have to change to allow the code to do more than just outputs from C1, "Yes" or "No"?

And my last question is, how can I put it in there that if "Yes" then make cell G1=1, H1=1, I1=500, J1=200, K1=400 and do that for drop box in C2.. C3 etc.

Thank you very much for all of your help!!