View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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.