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" <BudHughes@discussions.microsoft.com> wrote in message
news:CAA3085A-642D-4645-ADC5-24FF9673599E@microsoft.com...
|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?