Hello. My file consists in making copies of the main work sheet to make some modifications to them and to finally export them as a PDF file. The problem is that i have a complicated hierarchy in my conditional formatting and is very important to preserve it in the eventual copies BUT THIS DOESN'T HAPPEN!! whenever i copy the main sheet, the copy sheet changes the conditional formatting and i cant change back it manually because there is a macro that does this a significant amount of times. Any help? if i cant repair this is there a way to change the hierarchy using the macro so that the problem can be solved intermediately and automatically?