Copy and paste without Conditional Formatting

Hi Riz,

Try this code.
You stated A1:F5 in your first post, but your data is A1:F7.
I wrote code for A1:F5, you can probably figure out where to make the changes, there are two places.

Please Login or Register  to view this content.

Sorry re-read the initial post
you want the conditional format outcomes without the conditional formats

another alternative is to copy data, delete conditional format and replicate the "conditions" in VBA

Please Login or Register  to view this content.

i dont know how to write the rest....as the example the CF is broken as it points to external file

yeah sorry didnt read the post correctly

deleting the CF is easy part, replicating is not if the CF changes from file to file

sky's method would be the better choice in that case as you need to copy the display format rather than what the format actually is

Originally Posted by rizmomin

Hi humidangling:

Works great.
Thanks this would work.
Riz

really? im surprised unless i am reading the initial question incorrectly again

I have data in Sheet1 as shown. (Note the color in the Sales are due to Conditional formatting).

the CF is broken the example but i would of thought the CF changes some cells green?
if the cells are "showing" green on your real example and would not copy it green over to the backup
it would take the original color underneath

Thanks for the rep. points.