Help with hiding certain rows whilst others remain visible based upon multiple values.

Hi, I've got a VBA scripts working well where certain rows are hidden based upon values selected from drop-down lists in specific cells.

This is as below:
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:31,37:44,45:46,48:66,72:77,94:95,97:99,101:107,120:121,127:294").EntireRow.Hidden = Target.Value = "T3/T4"
If Target.Address = "$C$4" Then Range("122:126").EntireRow.Hidden = Target.Value = "No"

End Sub

What I now need some help with is to develop this code so that if the answer to the 2nd If Target .Address question isn't "T3/T4" and is "T1/T2" instead, and the answer to another question (which I will be adding so that the answer is in C5) is "No" how can I make specific rows hidden with that combination?

Hopefully, that makes sense.

Simon.

If you're changing C5 as part of this event, then you probably need to disable events.

Private Sub Worksheet_Change(ByVal Target As Range)
With Target
    If .Cells.Count > 1 Or .Value = "" Or .Column <> 3 Then Exit Sub
    Application.EnableEvents = False 'if you're going to be changing C5
    Select Case .Row
        Case 2
            Range("78:93").EntireRow.Hidden = (.Value = "No")
        Case 3
            Select Case .Value
                Case "T3/T4"
                    Range("16:29,31:31,37:44,45:46,48:66,72:77,94:95,97:99,101:107,120:121,127:294").EntireRow.Hidden = True
                Case "T1/T2"
                    Range("16:29").EntireColumn.Hidden = ([c5] = "No") 'Replace range accordingly
            End Select
        Case 4
            Range("122:126").EntireRow.Hidden = (.Value = "No")
    End Select
End With
Application.EnableEvents = True
End Sub