Forum Discussion
Conditional formatting using tolerances
MicLima Yes, this would work with the rule I wrote as-is. The only difference is that I assumed that your negative tolerances would be expressed as positive numbers (your original example had a 0 negative tolerance so I couldn't tell either way). Fixing for the correct sign:
=OR(D3-$A2>$B2, D3-$A2<$C3)
MicLima Something like this (written for cell D3; use dollar signs as I have and this rule can be applied to all cells):
=OR(D3-$A2>$B2, $A2-D3>$C3)
Savia Thanks for the help! I updated the original post; is there a way to do this for multiple sources and tolerances for all cells? I tried playing around with the absolutes, but couldn't get it to work right.
MicLima Yes, this would work with the rule I wrote as-is. The only difference is that I assumed that your negative tolerances would be expressed as positive numbers (your original example had a 0 negative tolerance so I couldn't tell either way). Fixing for the correct sign:
=OR(D3-$A2>$B2, D3-$A2<$C3)
