Sub Worksheet_Change(ByVal Target As Range)

If [Data1] = "Yes" Then
[Test1].EntireRow.Hidden = True
Else
[Test1].EntireRow.Hidden = False
End If

If [Data2] > 10 Then
[Test2].EntireRow.Hidden = True
Else
[Test2].EntireRow.Hidden = False
End If

End Sub