Hi

i am trying to set up a inspection sheet to highlight if a product is out of tolerance.

e.g. product comes in and should be 100mm wide - it is measured and is 101mm wide and the tolerance is +/- 0.5 then it is out of tolerance and i would like the cell to change to red.

this formula is the best shot at it:

="IF(OR($G$5=>0.5,$G$5=<0.5))"

any ideas please as this clearly doesn't work lol

thanks