Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-10-2013, 02:57 AM
spk spk is offline Copy format created by a conditional formatting Windows 7 64bit Copy format created by a conditional formatting Office 2010 32bit
Novice
Copy format created by a conditional formatting
 
Join Date: Apr 2013
Posts: 6
spk is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 04-10-2013, 03:38 AM
OTPM OTPM is offline Copy format created by a conditional formatting Windows 7 32bit Copy format created by a conditional formatting Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Have a look at this link which may help you.
http://www.pcreview.co.uk/forums/pas...l-t935189.html
Good luck.
Tony
Reply With Quote
  #3  
Old 04-10-2013, 04:41 AM
spk spk is offline Copy format created by a conditional formatting Windows 7 64bit Copy format created by a conditional formatting Office 2010 32bit
Novice
Copy format created by a conditional formatting
 
Join Date: Apr 2013
Posts: 6
spk is on a distinguished road
Default

Quote:
Originally Posted by OTPM View Post
Hi
Have a look at this link which may help you.
http://www.pcreview.co.uk/forums/pas...l-t935189.html
Good luck.
Tony
No, I want to do almost the opposite

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy format created by a conditional formatting 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
Copy format created by a conditional formatting 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
Copy format created by a conditional formatting help with conditional formatting Snvlsfoal Excel 3 07-03-2011 11:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft