Adding conditional formatting

Good morning to all,

I have conditional formatting code that works fine on its own but I have this existing code, courtesy of TMSchucks which provides a union of two existing changes. (below)

Please Login or Register  to view this content.

The code I have for the conditional formatting is below:

Please Login or Register  to view this content.

I can see that I could modify the existing code to suit if the conditional formatting code referred to a specific column, (I would choose case 17) but it is a range, so I am a bit stuck of how to combine it.

Any guidance much appreciated.

Thank you.

Simpler ?

Please Login or Register  to view this content.

It should perform the same task as the code TMShucks offered.

It's meant to replace all THShucks's code.