Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy Paste Conditional Formatting
I have used conditional formatting to identify certian parameters. I must
now copy that column to another spreadsheet but do not want to lose that highlighted data. I have tried Copy Paste Special but I can only copy the Values. Is there any way to copy those cells and the colors? |
#2
|
|||
|
|||
If you do a copy/paste special/formats, you'll get the conditional formats
(and other formats) into the destination cells, without changing the values already in those cells. -- Jim "Bud Hughes" wrote in message ... |I have used conditional formatting to identify certian parameters. I must | now copy that column to another spreadsheet but do not want to lose that | highlighted data. I have tried Copy Paste Special but I can only copy the | Values. Is there any way to copy those cells and the colors? |
#3
|
|||
|
|||
Bud
Try Paste SpecialFormats then Paste SpecialValues. Gord Dibben Excel MVP On Fri, 30 Sep 2005 06:11:06 -0700, "Bud Hughes" wrote: I have used conditional formatting to identify certian parameters. I must now copy that column to another spreadsheet but do not want to lose that highlighted data. I have tried Copy Paste Special but I can only copy the Values. Is there any way to copy those cells and the colors? |
#4
|
|||
|
|||
After reading my note I realized I was not very clear. I will be copying the
data to another spead sheet, and the data that turns on the conditional formatting will NOT be going with. Therefore when I paste or paste special the colors will no longer be there. So is there a way to copy the colors and the values but not the conditional formating? "Gord Dibben" wrote: Bud Try Paste SpecialFormats then Paste SpecialValues. Gord Dibben Excel MVP On Fri, 30 Sep 2005 06:11:06 -0700, "Bud Hughes" wrote: I have used conditional formatting to identify certian parameters. I must now copy that column to another spreadsheet but do not want to lose that highlighted data. I have tried Copy Paste Special but I can only copy the Values. Is there any way to copy those cells and the colors? |
#5
|
|||
|
|||
Bud
Have you tried it? Gord On Fri, 30 Sep 2005 15:04:02 -0700, "Bud Hughes" wrote: After reading my note I realized I was not very clear. I will be copying the data to another spead sheet, and the data that turns on the conditional formatting will NOT be going with. Therefore when I paste or paste special the colors will no longer be there. So is there a way to copy the colors and the values but not the conditional formating? "Gord Dibben" wrote: Bud Try Paste SpecialFormats then Paste SpecialValues. Gord Dibben Excel MVP On Fri, 30 Sep 2005 06:11:06 -0700, "Bud Hughes" wrote: I have used conditional formatting to identify certian parameters. I must now copy that column to another spreadsheet but do not want to lose that highlighted data. I have tried Copy Paste Special but I can only copy the Values. Is there any way to copy those cells and the colors? |
#6
|
|||
|
|||
After reading my note I realized I was not very clear. I will be copying the
data to another spead sheet, and the data that turns on the conditional formatting will NOT be going with. Therefore when I paste or paste special the colors will no longer be there. So is there a way to copy the colors and the values but not the conditional formating? "Gord Dibben" wrote: Bud Have you tried it? Gord On Fri, 30 Sep 2005 15:04:02 -0700, "Bud Hughes" wrote: After reading my note I realized I was not very clear. I will be copying the data to another spead sheet, and the data that turns on the conditional formatting will NOT be going with. Therefore when I paste or paste special the colors will no longer be there. So is there a way to copy the colors and the values but not the conditional formating? "Gord Dibben" wrote: Bud Try Paste SpecialFormats then Paste SpecialValues. Gord Dibben Excel MVP On Fri, 30 Sep 2005 06:11:06 -0700, "Bud Hughes" wrote: I have used conditional formatting to identify certian parameters. I must now copy that column to another spreadsheet but do not want to lose that highlighted data. I have tried Copy Paste Special but I can only copy the Values. Is there any way to copy those cells and the colors? |
#7
|
|||
|
|||
If the range is small, try pasting into MSWord. Then copy from MSWord and paste
back to excel. Bud Hughes wrote: After reading my note I realized I was not very clear. I will be copying the data to another spead sheet, and the data that turns on the conditional formatting will NOT be going with. Therefore when I paste or paste special the colors will no longer be there. So is there a way to copy the colors and the values but not the conditional formating? "Gord Dibben" wrote: Bud Have you tried it? Gord On Fri, 30 Sep 2005 15:04:02 -0700, "Bud Hughes" wrote: After reading my note I realized I was not very clear. I will be copying the data to another spead sheet, and the data that turns on the conditional formatting will NOT be going with. Therefore when I paste or paste special the colors will no longer be there. So is there a way to copy the colors and the values but not the conditional formating? "Gord Dibben" wrote: Bud Try Paste SpecialFormats then Paste SpecialValues. Gord Dibben Excel MVP On Fri, 30 Sep 2005 06:11:06 -0700, "Bud Hughes" wrote: I have used conditional formatting to identify certian parameters. I must now copy that column to another spreadsheet but do not want to lose that highlighted data. I have tried Copy Paste Special but I can only copy the Values. Is there any way to copy those cells and the colors? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy the formatted value and paste as a new value(not the original value with formatting)? | Excel Discussion (Misc queries) | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
Losing conditional formatting when saving | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
How do I use conditional formatting for multiple rows? | Excel Worksheet Functions |