conditional formating
 

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.

conditional formating
 

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)

wrote in message
oups.com...
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.

conditional formating
 

Thanks Bob, that did the trick!
Bob Phillips wrote:
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)

wrote in message
oups.com...
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.