Can text color follow paste special?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dzelnio - 14 Jul 2007 02:18 GMT

I have two worksheets linked by paste special and the source
information is colored text.

The text follows the link fine, but the color is lost. How do I make
that color follow the link?

Reply to this Message

JE McGimpsey - 14 Jul 2007 07:16 GMT

> I have two worksheets linked by paste special and the source
> information is colored text.
>
> The text follows the link fine, but the color is lost. How do I make
> that color follow the link?

The easiest way is to apply the same CF to the cell in the sheet with
the link.

The other way is to use a Calculation event macro.

Reply to this Message

Bob Greenblatt - 16 Jul 2007 13:29 GMT

On 7/14/07 2:16 AM, in article
jemcgimpsey-799B0E.00163914072007@msnews.microsoft.com, "JE McGimpsey"
<jemcgimpsey@mvps.org> wrote:

>> I have two worksheets linked by paste special and the source
>> information is colored text.
[quoted text clipped - 6 lines]
>
> The other way is to use a Calculation event macro.

Or, if I understand correctly, when you copy the source data and
paste-Special-Values in to the destination location, if you then immediately
Paste-Special_Formats, the destination text will be appropriately colored.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

JE McGimpsey - 16 Jul 2007 15:24 GMT

> > The easiest way is to apply the same CF to the cell in the sheet with
> > the link.
[quoted text clipped - 3 lines]
> paste-Special-Values in to the destination location, if you then immediately
> Paste-Special_Formats, the destination text will be appropriately colored.

Yup - I forgot that paste-special-formats would copy the CF as well.
Much better.

Reply to this Message

Mac Forum / Applications / Excel / July 2007

Can text color follow paste special?