Forum Discussion
Solved
Conditional formatting using tolerances
Hi, How would I write the formula to format the below cells if they are out of tolerance? Thanks in advance! E F G H I J K L M 13 Nominal Value Tolerance (+) Tolerance ...
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)
karina8581 This is what the final equation looks like in reference to cells in the original post. Hope it helps.
MicLima Wow! That worked!! Thank you.