would something like this work guys?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "A3" Then
If Target.Value = "Consolidated" Then Rows("15").EntireRow.Hidden = False
If Target.Value <> "Consolidated" Then Rows("15").EntireRow.Hidden = True
End If
End Sub