Conditinal formatting - AND function
 

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(a3b3),(a3<c3)
almost exactly like an example for AND function.
I appreciate any tips.

Conditinal formatting - AND function
 

=AND(A3B3,A3<C3)

Biff

"MariusSZ" wrote in message
...
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(a3b3),(a3<c3)
almost exactly like an example for AND function.
I appreciate any tips.

Conditinal formatting - AND function
 

"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....
formatconditional formattingcondition 1
cell value is : between : go to click cell b3 : go to click c3
choose color


"MariusSZ" wrote:

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(a3b3),(a3<c3)
almost exactly like an example for AND function.
I appreciate any tips.