Home |
Search |
Today's Posts |
#1
|
|||
|
|||
More Conditional Formatting
Hi I need to use one condition to judge whether or not a cell is 90-95% of
target or 100-105% of target. The other two conditions will be used, so i need to get this into one condition. Any help would be great. Thanks |
#2
|
|||
|
|||
KCi,
Use "Formula is." =OR(AND(A2=Target*90%, A2 <= Target*95%),AND(A2=Target*100%, A2<=Target*105%)) -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "KCi" wrote in message ... Hi I need to use one condition to judge whether or not a cell is 90-95% of target or 100-105% of target. The other two conditions will be used, so i need to get this into one condition. Any help would be great. Thanks |
#3
|
|||
|
|||
With the Target in $a$1:
and the value to be checked in A2: =OR(AND(A2/$A$1=0.9,A2/$A$1<=0.95),AND(A2/$A$1=1,A2/$A$1<=1.05)) (I'm not sure if you want the "or equal to" portion of the inequalities.) KCi wrote: Hi I need to use one condition to judge whether or not a cell is 90-95% of target or 100-105% of target. The other two conditions will be used, so i need to get this into one condition. Any help would be great. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Losing conditional formatting when saving | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |