Code:
Sub M_snb()
    [C7:C25000] = [if(B7:B25000>=A4,B7:B25000,"")]
End Sub