Data Validation If Statement

In the visual basic editor, put this code in the section for which ever worksheet this applies to:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range("C1").Address Then
    If Target = "No" Then
        Target.Offset(, 1).Resize(1, 3).Value = 0
    End If
End If

End Sub

This line establishes the range which the value is set to 0

Target.Offset(, 1).Resize(1, 3)

In your scenario Target will always be cell C1. If you want to apply code to cell G1 you would offset by 4 columns (i.e. Target.Offset(,4))
Then if you want to further expand to cover columns H, I, J, and K you would resize the range appropriately. Ex:

Target.Offset(, 4).Resize(1, 5).Value = 0

The macro was written to only work on cell C1 as was indicated in the original post. Below I has supplied a new code to work for any cell in column C and incorporate the newly supplied information.

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("C:C")) Is Nothing Then
    If UCase(Target) = "NO" Then
        Target.Offset(, 4).Resize(1, 5).Value = 0
    ElseIf UCase(Target) = "YES" Then
        Target.Offset(, 4) = 1
        Target.Offset(, 5) = 1
        Target.Offset(, 6) = 500
        Target.Offset(, 7) = 200
        Target.Offset(, 8) = 400
    End If
End If

End Sub