I NEED KEEP THE CONDITIONAL FORMATTING

Works for me....

From your previous questions I assume you want to copy the conditional formatting of your data. However in this workbook column "A" seems to be a picture of your data, rather than the data itself, so the 'CopyCF' macro in this workbook copies column "J" to Column "M".
29016968.xlsm

Hello Adriana,

From the colors of the source I presume that there is a custom conditional formating created.
In order to help you we need to know at least what is the conditional formatting properties set on the original sheet. Under what circumstances the cells will get different color?

Also, are you copying the whole range of values from the original column or only a couple of them?

If in the original file the conditional formatting is set to make cells green under certain condition then this condition might change if you just copy and paste part of the values.

For example if you make conditional formatting for values from 1 to 100 to be colored gradually from red to yellow to green, then if you copy and paste cells with values ranging only from 50 to 60 the 50-s will be red and 60-s green although in the original file 50 and 60 will be yellow-ish.

Please be more specific what ranges, formulas and values are contained in the original. Screenshot of the custom formatting will be helpful as well.

THANK YOU GENTLEMEN

Yes Martin the first column un the example is in pic of the original
because that wahta i have in the original source and that whats I need to show in the last

but when y copy and paste I lost the color in the paste area
that waht i need keep the colors on

the second column of the example i post is what i get
the colors are off  thats no what i want

the third column is after I put the color with the rigth click and fill tool

the second column in the exampl have the original conditional formatting
as the source original but don't show the colos

what i want is keep the colors after I make the copy and paste  in the new woorkbook

Edward Pamias how do you do ??

what i want is keep the colors after I make the copy and paste  in the new woorkbook

Did you look at the macro in my workbook? That's what you need.

Nikolay Tomov

what i mean i need make an copy and paste
but keep the color show in the paste area
and o loose the colors after the paste

and o loose the colors after the paste

You won't if you use my code.

Martin my good friend

the details here are  
when i paste from the oginal to the solution

for example

you make an woorkbook solution
then i need use it

i need copy from the original source to paste
to you solution tehen in that paste i lost the color
so when you solution make the process the input  dont have the colors in

Martin Im testing the woorbook you post but nothing happens !

Did you run the macro?

Martin can i run the macro in the souce to capture the color in the original source of data
so when i paste  i will paste the colors too?

Martin i run the macro
but i have to have the colors already in and that's the problem I have

i don't want put the color manually because the are a lot
i want it capture the original color from the original source

It doesn't matter if the colors are there or not. The code copies the conditional formatting along with everything else.

Ok I understand

you give an good idea

my original source is  in column BQ

i want just copy and paste to the place i need it

can you do ??

i mean you code can be modified ?

Martin Great !!
 what if iwant take to another woorbook !

lets say copy from woorbook A and paste to woorkbook B or CC

can be ???

Export Module1 from my workbook and Import it into workbook B or CC. Copy the date from Workbook A to workbook B or CC. Optionally change the code i talked about in post ID: 42098092, and run the macro,

you mean i have to put the code in the source (woorkbook A) and the destination  (workbook B or C)???

The code only needs to be in the destination workbook. Once the data is in the destination workbook you execute the macro in the destination workbook.

Great Job !!!

Thanks Very Much ! !

You're welcome.