Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formula - Need Help
Hello,
I would like some help in evaluating the value of a cell that falls within a certain range. For example: If A2 is less than 1 and greater than 10 "TRUE" Your help is appreciated. Ed |
#2
|
|||
|
|||
Hi Eduardo
do you mean if A2 is less than 1 OR greater than 10??? if so format / conditional formatting formula is =OR($A2<1,$A210) or if you mean greater than 1 and less than 10 =AND($B11,$B1<10) Cheers JulieD "Eduardo" wrote in message ... Hello, I would like some help in evaluating the value of a cell that falls within a certain range. For example: If A2 is less than 1 and greater than 10 "TRUE" Your help is appreciated. Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
=IF Statement formula or conditional formatting | Excel Worksheet Functions | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formula to search ranges?? | Excel Discussion (Misc queries) | |||
Syntax For Conditional Formula | Excel Worksheet Functions |