"If" and Syntax to change font and fill (interior) color based on cell value

[jdfjab]

How do I structure my If statement to change the font and fill color if the cell value is between -500 and 500? I have the following code which works with debug.print where I would like to change the font and fill colors.

ThisWorkbook.Worksheets("lastmaintenance").Range("M1").Select
    
    nOffSetRow = 1
    
    Do Until ThisWorkbook.Worksheets("lastmaintenance"). _
    Range("M1").Offset(nOffSetRow).Value = ""
    
       MileageSvcDo = CInt(ThisWorkbook.Worksheets("lastmaintenance"). _
       Range("M1").Offset(nOffSetRow).Value)
       
       'what is the syntax to
       'change the font(to color -16383844)
       'and fill color (to color 13551615)
       'if the value of MileageSvcDo
       'is > -500 And < 500
       
       End If
           
    nOffSetRow = nOffSetRow + 1
    
    Loop