Prev: Changing coler of tracking cells
Next: Comparing Two Sheets
From: Banker on 7 Apr 2010 16:55
I have a cell on sheet 1 that I have added text to with some bolding,
coloring of text, etc. On Sheet 2 I have a cell that I have told to copy
whatever is in the cell on sheet 1 described above. Why doesn't the
formatting copy over too??
From: Pete_UK on 7 Apr 2010 18:19
A formula returns a result, not any formatting.

Pete

On Apr 7, 9:55 pm, Banker <Ban...(a)discussions.microsoft.com> wrote:
> I have a cell on sheet 1 that I have added text to with some bolding,
> coloring of text, etc. On Sheet 2 I have a cell that I have told to copy
> whatever is in the cell on sheet 1 described above.  Why doesn't the
> formatting copy over too??

From: Gord Dibben on 7 Apr 2010 18:39
"told to copy" means you have used a linking formula such as =Sheet1!A1

Linking formulas do not bring over formatting............values only.


Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 13:55:01 -0700, Banker <Banker(a)discussions.microsoft.com>
wrote:

>I have a cell on sheet 1 that I have added text to with some bolding,
>coloring of text, etc. On Sheet 2 I have a cell that I have told to copy
>whatever is in the cell on sheet 1 described above. Why doesn't the
>formatting copy over too??

 | 
Pages: 1
Prev: Changing coler of tracking cells
Next: Comparing Two Sheets