Conditional Formatting Question

[jemchong93]

Hi experts,

I have a conditional formatting problem I need help with;

Context: I work in an manufacturing company and I want to check if my actual product dimensions are within the tolerance range. The excel sheet looks a little like this:

Column
1 A B C
2 Dimension Tolerance Product
3 0.30 ±0.01 0.2972


Basically, I want to use conditional formatting to check if my product dimension (column C - 0.2972) is within the dimension's tolerance (0.3±0.01). However, the problem is the ± symbol. I am not sure how to work with it.

Without the ± symbol, my formula for conditional formatting would be =OR(C3> A3 + B3, C3 < A3 - B3), which works without the ± symbol.

I have tried =OR(C3> A3 + abs(B3), C3 < A3 - abs(B3)), but it didnt work.

Would appreciate some help. Thank you!

Cheers
Jeremy

 

[jemchong93]

Sorry guys, I messed up on the excel sample. Basically, Column A is "Dimension" (0.30), Column B is "Tolerance" (±0.01) and Column C is "Product" (0.2972). And the formulaes should be row 2 instead of 3. Hope you guys understand what I'm saying!

Thank you
Jeremy