Tolerances in a temperature chart - conditional formatting - help!
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!
|