Highlighting discrepancies in a table

[cataholic]

Hi, I have a table I use to compare audiograms. What I would like is some way of highlighting when one reading in a specific frequency differs from another reading in that frequency by 5dB or more, plus or minus. I have tried conditional formatting and can create a formula to identify positive differences (ie if one cell is 20 and the previous is 15, it works). However, I cant copy that formula across the table as it reverts to absolute references no matter what i do. I dont know if this is because I am using a table rather than a chart, or if it is a glitch in Excel 365.

In any case, I think there must be a more 'elegant' way of doing this, and I would appreciate any suggestions.

 

[ETAF]

does this work
=AND(B21<>"",OR((B20-B21)>=5,(B20-B21)<=-5))

and can copy

=AND(B3<>"",OR((B2-B3)>=5,(B2-B3)<=-5))

I applied to B21:B29 and B3:B9

If not then please colour the cells you want highlighted and why ?

 

[cataholic]

Yes! In fact, I'll go further-Yesssssss!!!
And, looking at your formula I can see why I was getting nowhere with IF statements.
Thank you so much for your help.

 

[ETAF]

glad to have helped out