#1
|
|||
|
|||
Copy format created by a conditional formatting
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? |
#2
|
|||
|
|||
Hi
Have a look at this link which may help you. http://www.pcreview.co.uk/forums/pas...l-t935189.html Good luck. Tony |
#3
|
|||
|
|||
Quote:
Like I did it now, Excel copies the Conditional Formatting. I want to copy the color given by the CF, without the "dynamic part" created by the CF. Indeed, when the source data will change, it should not affect the destination. Thanks for your support anyway |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional format for form drop-down list? | pmregan | Word | 1 | 09-19-2012 07:09 PM |
Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |
Conditional formatting with AND, OR | Lucky | Excel | 2 | 10-03-2011 11:41 PM |
Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |
help with conditional formatting | Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |