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

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

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