Bernard,

Thank you for the advice on color usage. My spreadsheet is a couple of
printed pages long. The effect I'm after with the colors is to easily
identify over and under spec conditions (+-1°C) as well as "warning sign"
conditions (=- .5° to +-.9°). More than 95% of the values are within spec so
there is no color there. With your help, the out of spec cells stand out
quite nicely and will help the engineers correct the calibration curve easily.

The yellow formula doesn't seem to be working as expected - I have temp
values that are less than +-.5 that are getting the yellow when that should
not be the case and values that should be yellow are not. I highlighted my
entire data set, added the yellow rule as you wrote it. I'm simply not sure
why it doesn't perform correctly.

Any additional assistance would be greatly appreciated! Thank you a thousand
times over for your help!

"Bernard Liengme" wrote:

I think this is what you want
=AND(ABS($A2-B2)=0.5,ABS($A2-B2)<=1)

Be careful with colours. Many people (men) are red colour blind and yellow
is really hard to read
I experimented: gave all the cells a light grey fill and in conditional
formatting I used coloured borders rather than font colour. Looked quite
nice!

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email