Hide Rows based on Cell value

[therealjdj]

Hey folks,
I am creating an excel form that will be used to fill out some data. Based on the data being entered I might require additional information entered in other cells.

So I need help hiding rows based on values of other cells. Let's say cell B5 is "no" then I might want to hide rows 15-20. And if cell B7 is "yes" then maybe rows 26-31 have to be hidden...
Now there could be 5 of these situations. So it's not just these 2 - they were just an example.
I would like for these things to happen automatically and not after pushing a button.

Thank you for any help!

I did find some other posts asking a similar questions, but nothing that really did what I needed.

 

[therealjdj]

Was able to find an answer!
Values aren't the same as I stated above, but this code works.

Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Activate
If Not Application.Intersect(Range("C5"), Range(Target.Address)) Is Nothing Then
Select Case Target.Value
Case Is = "Canada": Rows("19:25").EntireRow.Hidden = True
Rows("7:18").EntireRow.Hidden = False
Case Is = "India": Rows("19:25").EntireRow.Hidden = False
Rows("7:18").EntireRow.Hidden = True
Case Is = "": Rows("19:25").EntireRow.Hidden = False
Rows("7:18").EntireRow.Hidden = False

End Select
End If