Formula with tolerance & conditional formatting

[Jim Simpson]

I am trying to add a formula which looks at 2 results, also a set tolerance. Should the second result be within tolerance of the first result then the cell would need to be formatted green or red dependant on within/outside tolerance.

eg 1
result 1 - 15.96
result 2 - 15.92
Tolerance - 0.1

eg 2
result 1 - 0.144
result 2 - 0.152
Tolerance - 0.002%

Can you shed any light on this. Thanks

 

[pbornemeier]

Assuming Result 1 is in column A, Result 2 in column B, Tolerance in Column
Use these conditional formatting formula:
=ABS($A2-$B2)>$C2 and set the fill to be Red when the formula is true
=ABS($A2-$B2)<=$C2 and set the fill to be Green when the formula is true