would you mind explaning the image
with some examples of expected results and why
mean/target = 2.8
Tolerance is +/- 0.1
and result is 2.9
so NOT coloured
BUT
mean/target = 0.5
Tolerance is +/- 0.006
and result is 0.508
so thats no good as the tolerence is 0.006 - so
0.494 or 0.506 is the range
so i have used ABS() and subtracted the result from the target - so we get + regardless
and then compared to the tolerance
is that what you are after
for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting
Highlight applicable range >>
F2:F100 - Change, reduce or extend the rows to meet your data range of rows
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=ABS($F2-$C2)>$D2
Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK