Hi Eduardo
do you mean if A2 is less than 1 OR greater than 10???
if so
format / conditional formatting
formula is
=OR($A2<1,$A210)
or if you mean greater than 1 and less than 10
=AND($B11,$B1<10)
Cheers
JulieD
"Eduardo" wrote in message
...
Hello,
I would like some help in evaluating the value of a cell that falls within
a
certain range.
For example:
If A2 is less than 1 and greater than 10 "TRUE"
Your help is appreciated.
Ed
|