Conditional Formatting for a range situation
 

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 +/- 2.5% and < = 5.0% {example 97.4% to 95.0%
and 102.6 to 105.0 = Yellow)
3) Red if value in cell +/- 5% {example 94.9% and less and 105.1% and
higher = red.

I am using Conditional Formatting with condition #1 = Formual is
'AND(+b40.9749,+b4<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.

Conditional Formatting for a range situation
 

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(+b40.949,+b4<1.051)

and the last range in the 3rd condition



"JayF" wrote:

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 +/- 2.5% and < = 5.0% {example 97.4% to 95.0%
and 102.6 to 105.0 = Yellow)
3) Red if value in cell +/- 5% {example 94.9% and less and 105.1% and
higher = red.

I am using Conditional Formatting with condition #1 = Formual is
'AND(+b40.9749,+b4<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.

Conditional Formatting for a range situation
 

Here's one way

condition 1 red
=(B4<"")*(ABS(B4-1)0.05)

condition 2 yellow
=(B4<"")*(ABS(B4-1)0.025)

condition 3 green
=(B4<"")*(ABS(B4-1)0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527766

Conditional Formatting for a range situation
 

Here's one way

condition 1 red
=(B4<"")*(ABS(B4-1)0.05)

condition 2 yellow
=(B4<"")*(ABS(B4-1)0.025)

condition 3 green
=(B4<"")*(ABS(B4-1)0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527766

Conditional Formatting for a range situation
 

Excellent. Simple and direct...I like it

"daddylonglegs" wrote:


Here's one way

condition 1 red
=(B4<"")*(ABS(B4-1)0.05)

condition 2 yellow
=(B4<"")*(ABS(B4-1)0.025)

condition 3 green
=(B4<"")*(ABS(B4-1)0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527766