<p>Using a macro I have consolidated info from several workbooks into one sheet in new workbook.</p>

<p>In one column  I have created a named range called ColRange.  That column has numbers ranging from -350 to 500.</p>

<p>How do I change the color of the cells based on the value of the text in the cell.<br>
red(0-500) 
yellow(-5-0)
green(-350--5)</p>

Assume that value is the number stored in the column then:
```
```
If value >= 0 AND value <= 500 Then
    ColRange.Interior.Color = RGB(255,0,0)
ElseIf  value >= -5 Then
    ColRange.Interior.Color = RGB(255,255,200)
Else
    ColRange.Interior.Color = RGB(0,255,0)
End If
```
```
And assuming that values greater than 500 or less than -350 is either not possible or validated by your script. Also, your ranges overlap a bit, what color should 0 be? Red or Yellow?