On Thu, 24 Nov 2005 06:20:07 -0800, "John"
wrote:

I need to use three colors with multiple conditions;
green = 5.6-6.0 or 6.1-7.0
Yellow= <700 or 900
Red= 1.1-3.8 or 2.0-5.9 or 5.0-6.9
They are in rows; B12 and row C13 and rowD14.
I'm ok with the cells, but not formulas. I appreciate you in advance!

Thanks, Heat.

Is 6.1 (for instance) green or red? The conditions seem to overlap.

Rgds

Richard Buttrey
__