CONDITIONAL FORMAT
That's okay, we don't do Thanksgiving over here. I don't understand why you
had to change B to A from your original post, but I am sure that you do, and
that is all that matters.
Regards
Bob
"John" wrote in message
...
Bob, we shouldn't be working on Thanksgiving, however, thanks! It worked,
but
I needed to replace B with an A otherwise is colored one cell over. Thanks
again!
HEAT.
"Bob Phillips" wrote:
Select all of B12, C13 and D14
=OR(AND(B12=5.6,B12<=6),AND(B12=6.1,B12<=7.0))
=OR(B12<700,B12900)
=OR(AND(B12=1.1,B12<=3.8),AND(B12=2.0,B12<=6.9))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"John" wrote in message
...
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.
|