Hello,

I'm creating a macro which copy values from a spreadsheet to another one.
It works fine for the values, but I'd like to copy also the cell color.

The problem is that the cell color is given by a conditional formatting.
When I use the function "special paste > format", Excel doesn't copy and paste the color itself, but the conditional formatting.
And in the destination file, the condition is not valid anymore...



The color in the destination file should not be linked to the source file.
So is there a way to copy and paste the "result" of the conditional formatting?