How can I make a cell a certain color dependent on number value?

[Sue]

I am wondering if it is possible to come up with a formula that colors cells
dependent on the numerical value. (ie If a=30 color will be blue, if a=40
color will be red, etc.)

Thanks

 

[Pat Flynn]

Hi Sue,
You can do this with conditional formatting under format.
Pat