So I am new to working with macros (I need things dumbed down for me lol)

I am working on an "interview questionare"

What I am working on for work is SHOW rows or populate a ROW (that is currently hidden with a question on it) based off of a cell that has a data validation list with YES and NO.

For instance, if I have a cell C35 with a data validation list of YES and NO I need it to "show" the hidden row 37 that has an additional question if the answer is NO.

If the answer is YES, I would like it to stay hidden. Is this possible? And if so, how do I customize it for other similar situations on the same questionaire. I am clueless when it comes to macros and getting them to run off of an answer with data validation. To be honest, I don't even clearly understand how to get it where I need it. I have SEVERAL questions like this. Some need to populate MULTIPLE rows. I have done my research and tried my best to edit other macros that are similar, but they just aren't working for me. PLEASE HELP!