software

Attempting to write a conditional format as follows:
1) Green if value in cell is /- or = 2.5% {example 97.5% to 102.5% = Green}
2) Yellow if value in cell is /- gt;2.5% and lt; = 5.0% {example 97.4% to 95.0%
and 102.6 to 105.0 = Yellow)
3) Red if value in cell gt; /- 5% {example 94.9% and less and 105.1% and
higher = red.

I am using Conditional Formatting with condition #1 = Formual is
'AND( b4gt;0.9749, b4lt;1.0251)'. Question. How do I write the next two
conditions? Is there a logic stmt for less then and equal? Greater then or
equal. I am new at this. Hope there is a template for this type of
Conditional formatting.

Since the conditional formatting is applied in the order of the conditions,
you can simply use the second range in the 2d condition, like so

=AND( b4gt;0.949, b4lt;1.051)

and the last range in the 3rd condition
quot;JayFquot; wrote:

gt; Attempting to write a conditional format as follows:
gt; 1) Green if value in cell is /- or = 2.5% {example 97.5% to 102.5% = Green}
gt; 2) Yellow if value in cell is /- gt;2.5% and lt; = 5.0% {example 97.4% to 95.0%
gt; and 102.6 to 105.0 = Yellow)
gt; 3) Red if value in cell gt; /- 5% {example 94.9% and less and 105.1% and
gt; higher = red.
gt;
gt; I am using Conditional Formatting with condition #1 = Formual is
gt; 'AND( b4gt;0.9749, b4lt;1.0251)'. Question. How do I write the next two
gt; conditions? Is there a logic stmt for less then and equal? Greater then or
gt; equal. I am new at this. Hope there is a template for this type of
gt; Conditional formatting.


Here's one way

condition 1 red
=(B4lt;gt;quot;quot;)*(ABS(B4-1)gt;0.05)

condition 2 yellow
=(B4lt;gt;quot;quot;)*(ABS(B4-1)gt;0.025)

condition 3 green
=(B4lt;gt;quot;quot;)*(ABS(B4-1)gt;0)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=527766
Here's one way

condition 1 red
=(B4lt;gt;quot;quot;)*(ABS(B4-1)gt;0.05)

condition 2 yellow
=(B4lt;gt;quot;quot;)*(ABS(B4-1)gt;0.025)

condition 3 green
=(B4lt;gt;quot;quot;)*(ABS(B4-1)gt;0)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=527766Excellent. Simple and direct...I like it

quot;daddylonglegsquot; wrote:

gt;
gt; Here's one way
gt;
gt; condition 1 red
gt; =(B4lt;gt;quot;quot;)*(ABS(B4-1)gt;0.05)
gt;
gt; condition 2 yellow
gt; =(B4lt;gt;quot;quot;)*(ABS(B4-1)gt;0.025)
gt;
gt; condition 3 green
gt; =(B4lt;gt;quot;quot;)*(ABS(B4-1)gt;0)
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=527766
gt;
gt;