I have a couple of macros for my spreadsheet and it seems the main one I run keeps changing the "Applies to" rule of my conditional formatting.

The macro is extremely simple, it just uses the "Remove duplicates" function to remove any duplicate numbers from one column.

My formatting:

It just formats the row of cells based on the checkbox values. Every time I use the remove duplicates macro the "Applies to" value changes to a bunch of specific, sectioned off cells, rather than the big range like I have it set to in the picture.

Is there a way to stop the remove duplicates macro from interfering with my conditional formatting? It's pretty annoying to have to go into the conditional formatting and change every value back to it's original