Formula Needed to fill multiple cells with "No" when the word "No" is entered into a cell

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

Enter this formula in D7 and copy across to F7:

=IF($C7="No","No","")

=IF($C7="No";"No";"")
I think this will do it.