Hi,

Can anyone help.........

In Excel A1:A100 I have a record of measurements taken, i.e A1 12,
A2 3, A3 14, A4 11, A5 15, A6 9, A7 8, A8 6 ect. One number occupies
one cell. In B1:B100 I want to write a formular for the following.

(Cell A3 being the example) Check the value in the cell which is 14
and see if it is within tolerance (10+/- 2).

If the value is <8 it returns a text string saying "Under spec" and
changes the cell colour to red. If the value is 12 it returns a text
string saying "Over spec" and changes the cell colour to Yellow.

I have tried but can't see a way to do it, without over complicating
it.

Thanks in advance