Conditional Formula - Need Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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,$A2>10)

or if you mean greater than 1 and less than 10
=AND($B1>1,$B1<10)

Cheers
JulieD
 
Back
Top