Conditional Formatting with overlapping ranges

Hi everyone,

I'm new to VBA programming, but with a lot of searching and studying code examples I have managed to make 3 working macros today. However I am stuck on the last one that I need to create. The aim is to have a macro that deletes and re-establishes our two conditional formatting rules on our sheet. The ranges overlap, and this seems to cause it the macro to stop working. If I run a version of the macro with either 1 rule at a time it works fine. If I run the whole thing with both rules, it gives a runtime error 438 and debug highlights the line ending xlDuplicate.

Please Login or Register  to view this content.

What changes can I implement to get this to work?

Also, I was hoping someone could please explain to me how this line of code works?

Please Login or Register  to view this content.

Thank you in advance!!

Please Login or Register  to view this content.

The .SetFirstPriority line makes a newly added condition the 1st condition. It's not really needed if you add them in the order you want them.