CONDITIONAL FORMAT
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.
|