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)
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)
MicLima
Can you provide the table image that references the final equation you are using for the conditional formatting?
For the equation, I dont see the columns you referenced in the equation. I am trying to copy off of yours but not sure which columns the equation is referring to. Thank you.karina8581 This is what the final equation looks like in reference to cells in the original post. Hope it helps.
