Thanks Dave, but I should have provide more info. What I would like to do is
go from green to red within a single cell. I tried patterns and they do not
provide what I am looking for.

"Dave O" wrote:

You touched on the answer in your question: you can set up conditional
formatting to shade a cell in a particular color for a given cell
value, then set up an additional conditional format (logically mutually
exclusive from the first) the shade a different cell color for a
different cell value. In the conditional formatting setup window, look
for the Patterns tab and cell shading.