Static Conditional Formating

[djl295]

I am running a macro that essentially moves a bunch of cells over. However, when I do this the conditional formatting on the cells I move over no long applies to these cells. When I check conditional formatting I notice that the range the formatting effects has changed. Is there a way to make it static?

Thanks a bunch

[ChemistB]

So for example, you have conditional formatting on columns D and E. Then you run a macro which moves these columns over to B and C. The conditional formatting moves with them but you want it to remain on D and E?

[ChemistB]

What are your current conditional formatting rules?