Conditional Formatting with overlapping ranges

[electricninja]

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!!

[AlphaFrog]

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.

[electricninja]

Hi AlphaFrog,

Thank you so much for your fast response. I tested the code you provided and I'm very glad that it is now working!