When I copy and paste a cells contents the conditional formats change.
I can see how that might be useful but in this instance I need to preserve the original conditional formatting contents exactly as they are.
When I copy and paste a cells contents the conditional formats change.
I can see how that might be useful but in this instance I need to preserve the original conditional formatting contents exactly as they are.
Seems you have not used absolute references to define it, so they are keeping with copying.