Hiding rows based on criteria working, however now unhiding based on selection changing

[Lifterlady16]

I've used a formula found in another post that is working for me, currently. It's to Hide rows based on a particular criteria as you select fields. However, if the user goes back and changes the criteria, it does not unhide the row in question. How do I alter this code to then unhide if the criteria changes?

Private Sub Worksheet_Change(ByVal Target As Range)
    If Range("B5").Value = "No" Then
        Rows("6:6").EntireRow.Hidden = True
    ElseIf Range("B6").Value = "Yes" Then
        Rows("6:6").EntireRow.Hidden = False
    End If
End Sub
[code]

 

[Fluff]

Hi & welcome to MrExcel
How are B5 & B6 being populated?
If you're happy just using B5 you can use this

Private Sub Worksheet_Change(ByVal Target As Range)
   Rows(6).Hidden = Range("B5").Value = "No"
End Sub

 

[Lifterlady16]

Fluff, thank you so much! This worked PERFECTLY, and I'm on my way now! Really appreciate it.

 

[Fluff]

Glad to help & thanks for the feedback