copy conditional format to regular format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GDC - 04 May 2005 00:28 GMT

We would like to have part of a spreadsheet with conditional formatting
pasted into a new document that shows the data the way it was conditionally
formatted in the original. Because the supporting data will not be there,
can we somehow convert the data to appear as in the original using regular
cell formatting?

Reply to this Message

Dave Peterson - 04 May 2005 03:34 GMT

This may work ok...

Edit|Copy your range and paste into MSWord. Then copy from there and paste into
the new worksheet/workbook.

or....

Edit|copy your range
go to the other sheet
Shift-Edit|paste picture

It's not "real" data--just a picture of the way things sat.

> We would like to have part of a spreadsheet with conditional formatting
> pasted into a new document that shows the data the way it was conditionally
> formatted in the original. Because the supporting data will not be there,
> can we somehow convert the data to appear as in the original using regular
> cell formatting?

Signature

Dave Peterson

Reply to this Message

GDC - 04 May 2005 16:36 GMT

Thanks, the Word trick did what we wanted (although it took a while with a
few hundred rows)

> This may work ok...
>
[quoted text clipped - 14 lines]
> > can we somehow convert the data to appear as in the original using regular
> > cell formatting?

Reply to this Message

Dave Peterson - 04 May 2005 21:35 GMT

You may want to try this against a copy of your workbook:

You may want to take a look at this similar thread:
http://groups-beta.google.com/group/microsoft.public.excel.misc/browse_thread/th
read/de46e4ac01d48c8b/fd768bb674d58088
(one line in your browser)

(This is the thread where I picked up the MSWord trick.)

> Thanks, the Word trick did what we wanted (although it took a while with a
> few hundred rows)
[quoted text clipped - 21 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message