Another way

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

    If Not Intersect(Target, Range("C35")) Is Nothing Then
        Rows(37).Hidden = (Target.Value = "No")
    End If

End Sub