And if you want a starter macro for you, just make sure you say the range that you want to check.
Such as you want to check A1:A10, if any cell value in this range is "yes", then hide the whole row, you could do this a few ways. Let's look at the following ...
'Ensure variable declaration
Option Explicit
'Test routine #1
'Union (fast)
Sub HideRows_Test1()
'Declare variables.
Dim rngCheck As Range, cel As Range, uCel As Range
'Set range to check for condition ("yes").
Set rngCheck = Range("A1:A10")
'Loop through each cell in the set range.
For Each cel In rngCheck
'Perform condition check on individual cells.
If cel.Value = "yes" Then
'If cells match condition, check if Union exists.
If uCel Is Nothing Then
'If it doesn't exist, create it.
Set uCel = cel
Else
'If it does exist, add to it.
Set uCel = Union(uCel, cel)
End If
End If
Next cel
'Hide all Unioned cells here.
uCel.EntireRow.Hidden = True
End Sub
'Test routine #2
'Standard Loop (faster)
Sub HideRows_Test2()
'Declare variables.
Dim rngCheck As Range, cel As Range
'Set range to check for condition ("yes").
Set rngCheck = Range("A1:A10")
'Loop through each cell in the set range.
For Each cel In rngCheck
'Perform If/Then condition check. If true, perform action.
If cel.Value = "yes" Then cel.EntireRow.Hidden = True
Next cel
End Sub
'Test routine #3
'Array check (fastest)
Sub HideRows_Test3()
'Declare variables.
Dim i As Long, celArr()
'Set range to check for condition ("yes").
celArr = Range("A1:A10")
'Loop through each variable in the array.
For i = LBound(celArr) To UBound(celArr) Step 1
'Perform If/Then condition check. If true, perform action.
If celArr(i, 1) = "yes" Then Range("A" & i).EntireRow.Hidden = True
Next i
End Sub
Hope This Helps