Dave-

thank you- this works (although the range is so large it is unreadable in
word, but it does copy over). I'm in Excel 2003 now, hopefully 2007 allows
us to specify an HTML-only copy/paste directly within Excel without going to
Word first. Maybe 2003 allows that too, but I'm not smart enough to figure
out how ;-)

Thanks,
Keith

"Dave Peterson" wrote in message
...
Maybe...

If you can select the range and copy into MSWord, you'll see the CF
coloring
kept.

Then you can copy from MSWord and paste into your new workbook.

Keith R wrote:

I have a workbook that uses conditional formatting (cell color) based on
values in named ranges. Now I need to copy one of the sheets out of the
workbook for a user. I can't provide the whole workbook (even with that
data
hidden) because data in other parts of the workbook are confidential.

I tried copy/paste that sheet to a new workbook (thinking I could just
not
update the links) but the colors in te cells of the destination workbook
only maintain their coloration while the old workbook is open (and
therefore
the named ranges are available for evaluation). Once the other workbook
closes, the conditional formatting can no longer access those named
ranges
and they lose their color.

Is there a way to copy/paste a worksheet while retaining the coloration,
similar to [paste special/values] for cell contents? Ultimately I need
something like [paste special/current color] which doesn't exist, but
hopefully that helps explain what I'm looking for.

Any ideas?

Thanks,
Keith

--

Dave Peterson