Copy and paste cells with Conditional Formatting

How do you copy cells that have Conditional Formatting and keep the Conditional Formatting?

I'm using this code, I see the formatting (albeit briefly) and then it goes away.

Please Login or Register  to view this content.

Not sure if this helps or not.

One way is to transfer the formatting conditions step by step.

Please Login or Register  to view this content.

Originally Posted by rvasquez

Hello there,

When you use the below line in your code

Please Login or Register  to view this content.

By usinf the line xlPasteValuesAndNumberFormats you are telling the code to only paste values and number formats and to drop all other formatting from the cell, including conditional formatting. Try using the below line of code to replace the line above.

Please Login or Register  to view this content.

Let me know if this works!

Thanks!

RVASQUEZ

This copied text only without conditional formatting.

I have found a workaround, since I am only copying data for a visual page with a chart the conditional formatting isnt really necessary.
So I added a couple macros to color cells as needed.

Please Login or Register  to view this content.

thank you for your input!