Excel hide or show rows
Show or hide rows based on content
Sub HideOrShowRows()
Dim A As Range
Set A = Range("A1:A103")
A.EntireRow.Hidden = False
For i = 1 To 103
If Cells(i, 1).Value <> "" And Cells(i, 1).Value = False Then
Cells(i, 1).EntireRow.Hidden = True
End If
Next i
End Sub
=IF( IFERROR(( SEARCH( "thingimfinding", N56, 1)), 0) = 0, "False", "True")