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.