conditional formating

J

jashburn13

Is there a way that I can use conditional formating for the following
scenerio? If 0.7<=x<=1.1 or if 1.3<=x<=2.2 the condition is good
otherwise the condition is bad.
 
B

Bob Phillips

Sure, use a Condition of Formula Is and a formula of

=OR(AND(A1>=0.7,A1<=1.1),AND(A1>=1.3,A1<=2.2))

where A1 would be the cell that holds the x value. If it is not A1 than you
wish to format but some other cell. make A1 absolute, $A$1.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
J

jashburn13

Thanks Bob, that did the trick!
Bob said:
Sure, use a Condition of Formula Is and a formula of

=OR(AND(A1>=0.7,A1<=1.1),AND(A1>=1.3,A1<=2.2))

where A1 would be the cell that holds the x value. If it is not A1 than you
wish to format but some other cell. make A1 absolute, $A$1.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
Top