Hi,

I'm having a problem with trying to do some conditional formatting.

I have several scores out of 5 such as

3.57 4.00 4.00 2.29 3.43

In column I , there is the average of these which is 3.46


I want to place conditional formatting so that if any of the scores varies from the average by more than 1 the cell will change to red. I tried the formula "Cell Values is equal to I22+1" & "Cell Values is equal to I22-1 ", however the cell containing 2.29 will not change to red.

Can someone tell me what I am doing wrong?

Thanks.