highlight cells with a value within 3 of other cells on the row

[cspgsl]

I am no Excel expert so I am looking to see if this is possible.

I have a table like you see here. On each row, I want to conditionally highlight any two cells in the Daily Yardage columns with the same colour if the values are within 3 of any other cell in any other Daily Yardage column within the same row.

In other words, I want to compare the values in G6, M6, S6, Y6 and AE6 and if any values are within 3 of another, change the colour on the two cells that are within 3.

I have manually done it here but the table is actually 31 rows (for a month) and I am trying different scenarios in each of the Tee and Hole columns.

Any help would be appreciated.
Thanks

 

[cspgsl]

It works as you have shown on screen

Thank you very much for your assistance and BIG thank you for all the effort that Jason put into the thread.

 

[jasonb75]

Thanks for stepping in, Fluff!

It turns out that the shorter formula from later posts was only working with the sample from post 1 because I had only typed out the yardage columns for testing, as an example the 200 in Y6 was being incorrectly highlighted because it was being compared to V6. Because V6 was empty in my test sheet I wasn't seeing the problem and the formula wasn't behaving as I thought it was.

 

[Fluff]

Glad we (mainly Jason) could help

Thanks for stepping in, Fluff!

No probs, I was intrigued why your original formula didn't work, but could think why.

 

[cspgsl]

Is there a way to mark the thread as Solved? It's something I look for in forums when trying to scout out an answer.

 

[Fluff]

No there isn't, we don't do that here.

 

[jasonb75]

I was intrigued why your original formula didn't work, but could think why.

From the appearance of the screen capture, I was thinking possible leading spaces in the headers due to the space above the text. The inclusion of a line break didn't occur to me.

 

[Fluff]

The inclusion of a line break didn't occur to me.

Snap