how can something like this be formatted to be working???
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
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