| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use formatting from source cell in CONCATENATE function | Excel Worksheet Functions | |||
| use formatting from source cell in CONCATENATE function | Excel Worksheet Functions | |||
| Formatting from a Function | Excel Discussion (Misc queries) | |||
| Conditionial formatting for merged cells, function Len($A$4) | Excel Worksheet Functions | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Linear Mode
