Sub MGexcel()
Dim c As Range
Dim mini As Integer, maxi As Integer
mini = 40
maxi = 60
For Each c In Range('F1:F5000')
If c > mini And c < maxi Then
c.EntireRow.Interior.ColorIndex = 7 'magenta
Else
c.EntireRow.Interior.ColorIndex = xlNone
End If
Next
End Sub