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?

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?

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?

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?

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?

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?

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