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

"Sue" wrote:

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