Conditinal formatting - AND function

M

MariusSZ

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

driller

"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
 
Top