Macro run depending on cell value

Hi,

Right click on the sheet's tab > View code.

Copy and paste in this procedure:

Private Sub Worksheet_Calculate()
    
    Dim rngToCheck As Range
    
    Set rngToCheck = Range("M3")
    
    If VBA.IsNumeric(rngToCheck.Value) Then
        
        If rngToCheck.Value > 10 Then
            Macro3
            
        ElseIf rngToCheck.Value >= 5 Then
            Macro4
            
        End If
    End If
End Sub