Conditinal formatting - AND function

[Guest]

Hi. I'm trying to get an AND function to work in conditional formatting. All
i want is to check if a number is in between to other numbers. Using formula
is :
=AND(a3>b3),(a3<c3)
almost exactly like an example for AND function.
I appreciate any tips.

 

[Biff]

=AND(A3>B3,A3<C3)

Biff

 

[Guest]

"All i want is to check if a number is in between to other numbers."

if you 're checking the number on cell a3 where you want to know if it is
between b3 and c3....
format>conditional formatting>condition 1
cell value is : between : go to click cell b3 : go to click c3
choose color