$$Excel-Macros$$ Conditional Formatting VBA problem

Hi again group, I can't find a way to preserve the condtional formatting on a worksheet when rows are pasted from another sheet. The condtional formatting from the sheet that is being searched transfers to the destination sheet and overwrites or completely removes the condtional formatting rule

$$Excel-Macros$$ Conditional Formatting VBA problem

Hi again group, I can't find a way to preserve the condtional formatting on a worksheet when rows are pasted from another sheet. The condtional formatting from the sheet that is being searched transfers to the destination sheet and overwrites or completely removes the condtional formatting rule