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