What is your question? Have you looked at help for conditional formatting?
What don't you understand?
--
David Biddulph

"Rezendes" wrote in message
...
I am testing 10 thermometers and using Excel for my data. There is a +/-3°
allowable tolerance. Column A is my set scale (-5°C to +5°C) and columns B
through K are my result figures for these devices. I'd like to
conditionally
format the cells of the results that are too low (-3) blue and if they
are
too high (+3) format the red.

Thank you for your help in advance!