Automatic running macros

Thank you for your answer. How can I make the macro hide/unhide the rows in question when a cell in the range G32:G56 is made to contain "Fail". Also how do I make it do that automatically? I am having trouble configuring it.

Thanks in advance!

Hi guys,

I figured it out! It allows the change in the result from the formula in B22 to trigger the macro. Here is the answer:

Private Sub Worksheet_Calculate()
    Dim Xrg As Range
    Set Xrg = Range("$B$22")
    If Not Intersect(Xrg, Range("$B$22")) Is Nothing Then
    ExtendedPopulation
    End If
End Sub

Thanks all for helping me!