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?

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.

GDC wrote:

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?

--

Dave Peterson

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

"Dave Peterson" wrote:

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.

GDC wrote:

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?

--

Dave Peterson

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/...768bb674d58088
(one line in your browser)

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

GDC wrote:

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

"Dave Peterson" wrote:

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.

GDC wrote:

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?

--

Dave Peterson


--

Dave Peterson