In this sheet I'm copying rows from one sheet if they are marked by a toggle "X" into another sheet. I notice that the conditional formatting on the destination sheet gets changed when the paste code is run. I think its because of the "RemoveDuplicates" that runs after the past function. Here is the code and an example workbook. Is there a way to keep the destinations conditional formatting ranges? Or somehow reset it? I need to keep the "removeDuplicats" or somehow do that because there are 2 columns of data being transferred and some of the data is a duplicate.
In the attachment the conditional formatting ranges are all correct on the protocol sheet. If you click the protocol button on the coherence sheet it will move the marked rows to the protocol sheet and then you can see how the conditional formatting ranges get changed.
Bookmarks