conditional formatting using a formula

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

hi Ninjabear.. for one you cant put """" in the if statement unless you want it to display that text.. and imo it is better to have a cell saying 0.5 then the formula can say =IF(OR($G$5>G1,$G$5<G1),TRUE,FALSE) but this wont work in conditional so you need to use =OR($G$5>G1,$G$5<G1) on conditional formatting

hi wayneg
take it back it does work i had to have a cell with -0.5 as well as 0.5

thanks
very much

hi Wayneg

that looks like what i was after but doesn't seem to work

Hi Fortis1991

the figure of 100mm was an example and could be anything so not sure that would work ?

thanks for the replys and other ideas?...please