C7 = the cell in which No or Yes will be entered (formula)
D7, E7, F7 = cells where the answer will input based on C7 entry.
Simply put if I enter "No" into C7 then D7, E7, and F7 will all have "No" appear.
If I enter "Yes" into C7 then C7, D7 and E7 remain empty.
Thanks
Bookmarks