Run Macro on Listbox Selection

Within the attached i want certain changes to occur on selection of Condition A

So if Condition A =Yes then I want the question in yellow (G33, G44, G50,G51) to automatically be set to "N/A", if it is condition A is either blank or No then these should be empty and free to select. Is the best way to achieve this via a Macro?

First, get rid of merged cell, advice in attached link explains how to use them.
Consider using a VBA/macro driven UserForm that cycles through the question then record the marks to a data sheet.
torachan.

https://excel.solutions/2016/10/usin...ctively-excel/

Thanks Torachan, noted not to merge cells. Certainly i can appreciate there are slicker ways to do this however I have a number of limitations (inc time) so am working with what i have / Know.

The data is also picked up on a seperate table however there are comments fields associated to each question and the intention is to use the forms to review the responses and comments were there are concerns.

I am simply trying to speed up the process of scoring by pre-populating fields where they can be

try the attached - macro on the Worksheet_Change event of 'D5'