Conditional formatting based on deviation values.

Hello guys..

i wanna ask , regarding my problem that i currently face now.

I need to do some conditional formatting but its quite complicated than the usual one. What i need is, every time i plug in the value into F7 and downwards for example, it will be compared to the value in their respective column A accordingly.

For example, column A may have the value such as,

1) Ø12.26 +0.001/-.005
2) R.20 ± 0.03
3) Ø5.64 ± 0.03
4) CHF 20° ± 2°

So once the values in column F is out of the deviation in column A ( not in between plus minus value) , it will change the cell color into red for every values which are inserted not within specified range in column A. So once i type the wrong value, i will be notified immediately.

You may refer to my attachment.

Thanks in advance.Really appreciate your help.

Thnaks for your opinion.I got ur idea..

So let say i has created a cell that can calculated the deviation value in Column E. But i want to do conditional formatting in column B, which can turn red if the value in column E is more than 100, or less than 0. (0>E>100). So everytime someone key in the wrong value in column B , he will be notified immediately.

i got some difficulties to find the setting, because the conditional format is in column B which based on value in column C.Here is my attachment.



Thanks in advance for entertaining my question

Thanks dude. Really appreciate ur help. Thats all what i need!

@ FDibbins,

"If you snooze you lose". I was snoozing, and you followed up and helped solving this thread!

Baie dankie.