Question about how to hide multiple rows based upon cell values.

Hi, hoping someone can help me please.

I would like to be able to hide multiple, specific rows based upon answers selected from a drop-down in multiple cells.

For example, on Row 2 the question is "Do you prefer Red or Blue?", if the user selects Red then rows 90-100 are hidden.

Then, on Row 3 the question is "Do you like Square or Round?", if the user selects Round then rows 110-120 and rows 150-160 are hidden.

I also then want them to revert to being visible if the opposite answers are selected for the questions on Rows 2 & 3 as above.

Hope that makes sense and THANK YOU for any VBA code.

Simon.

Thanks, will try this.

Seemed to work OK initially, then I got an issue about 'target range", as below in VBA:
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Then Exit Sub
If Target.Value = "" Then Exit Sub
If Target.Address = "$C$2" Then Range("78:93").EntireRow.Hidden = Target.Value = "No"
If Target.Address = "$C$3" Then Range("16:29,31").EntireRow.Hidden = Target.Value = "T3/T4"

End Sub

Think I've sorted it, changed the single 31 to 31:31........seems OK now.