Worksheet_Change event - hide/unhide columns based on multiple drop down list

Hello,

I would like to ask your support regarding a column hide/unhide issue. My target is to hide/unhide columns based on 4 drop down lists by Worksheet_Change event.

This is the code what I use now, here I have only 1 drop down list (in cell C10) and if I select "No" then the code hide these columns, if I select "Yes" then the code unhide these columns. It is working well.

Private Sub Worksheet_Change(ByVal Target As Range)
    
    If Not Intersect(Target, [C10]) Is Nothing Then
        Columns.Hidden = 0
        Select Case Target
        Case Is = "Yes"
            Range("H:H,K:K,N:N,Q:Q,T:T,W:W").EntireColumn.Hidden = False
        Case Is = "No"
            Range("H:H,K:K,N:N,Q:Q,T:T,W:W").EntireColumn.Hidden = True
        End Select
    End If
    
End Sub

But how should be modified this code if I would like to add more drop down list, like:
If the value in cell11 is "No" then these columns should be hided:
Range("I:I,L:L,O:O,R:R,U:U,X:X").EntireColumn.Hidden = True
If the value in cell11 is "Yes" then keep them unhided.

or

If the value in cell12 is "No" then these columns should be hided:
Range("J:J,M:M,P:P,S:S,V:V,Y:Y").EntireColumn.Hidden = True
If the value in cell12 is "Yes" then keep them unhided.

or

If the value in cell13 is "No" then these columns should be hided:
Range("E:E,F:F,G:G").EntireColumn.Hidden = True
If the value in cell13 is "Yes" then keep them unhided.

Thank you in advance for your support!

Another option would be

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Intersect(Target, Range("C10:C13")) Is Nothing Then Exit Sub
   Columns.Hidden = 0
   
   If Target.Row = 10 Then
      Range("H:H,K:K,N:N,Q:Q,T:T,W:W").EntireColumn.Hidden = Not Target.Value = "Yes"
   ElseIf Target.Row = 11 Then
      Range("I:I,L:L,O:O,R:R,U:U,X:X").EntireColumn.Hidden = Not Target.Value = "Yes"
   ElseIf Target.Row = 12 Then
      Range("J:J,M:M,P:P,S:S,V:V,Y:Y").EntireColumn.Hidden = Not Target.Value = "Yes"
   ElseIf Target.Row = 13 Then
      Range("E:E,F:F,G:G").EntireColumn.Hidden = Not Target.Value = "Yes"
   End If
End Sub

@mumps1
Shouldn't that be

If Target.Row= 10 Then

etc?

Hi Mumps1, Fluff13,

Thank you for your help!
I've tried your codes and there is an open point which is not solved yet. If I select only one "No" then the code hide/unhide the columns as expected but if I select more "No" value then the hiding/unhiding is not working properly.

Could you please see the attached sample file?

If you remove this line

   Columns.Hidden = 0

Does the code do what you want?

Yes, thank you very much!

Glad we could help & thanks for the feedback