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

"Rezendes" wrote in message
...
Thank you Bernard!

If you would be so kind, I have a follow up question because I am unable
to
create one additional CF rule. For reference, my actual tolerance is +-
1°C.
With your help, my spreadsheet now shows temps that are too low in blue,
too
high in red - thank you!

I'd like to add one more CF rule where the cell values X (when compared to
column A) are yellow under these conditions (both positive and negative -
perhaps using absolute value?): 1X.5

My trial and error attempts have all been errors to this point!
Thank you again for your invaluable assistance!



"Bernard Liengme" wrote:

My first reference value is in A2 (that has -5)
I selected B2:K11 and in the Conditional Formatting dialog used
Formula Is =B2-$A23 and set font colour to red
For the second one I used
Formula Is =$A2-B23 and set font colour to blue
You must have numbers in all cells
but you could use Custom Format of: 0 "°C" to display -5 as -5°C
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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!