Hide rows based on cell values

Perhaps you mean along the lines of:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A10:C10")) Is Nothing Then Exit Sub
Rows("150:200").Hidden = Application.CountIf(Range("A10:C10"), "Yes") < 3
End Sub