Try using Format - Conditional Format

This will work for 3 or fewer condions. If you have more than 3 conditions,
you'll need to do it with VBA.
--
HTH,
Barb Reinhardt



"janlanac" wrote:

I want to set up a mathmatical formula that will fill a cell with a specific
color that corresponds to the value the formula returns. For instance, if
the formula returns 99 - the cell would be green, if 70 it would be yellow
and if < 60 it would be red. Anyone know how to accomplish this?
--
jan