any help would be greatly appreciated

If Range("$A$42" > 0) And

Range("$A$42" < 1) Then

Range(H12) .Interior.ColorIndex = "yellow"

If Range("$A$42" > 1) And

Range("$A$42" < 2) Then

Range(H12:H13) .Interior.ColorIndex = "yellow"

If Range("$A$42" > 2) And

Range("$A$42" < 3) Then

Range(H12:H14) .Interior.ColorIndex = "yellow"

End If

End If

End If