How do I simplify this Code?

Hello, this code applies conditional formatting to data in 12 Excel columns. Each column is unrelated to the other column. How do I simply this code so it is not repeated 12x? Thank you.

This is a sample;

Please Login or Register  to view this content.

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Thanks Greg. I'm no developer so have to be honest..... getting that code to work on my XLS is a bit of a mystery. I kind of makes sense but getting it to work, well that's a whole other challenge..... If you had a spare 5minutes I could send you the XLS with the data Im trying to format..... but understand if you are busy.

Cheers.

Hi again,

Sure, no problem.

I'll send you my email address in a private message so that you can send it to me directly if you don't want to post all of the data here.

Regards,

Greg M