software

How can I have a cell equal another cell AND also include the formatting
of the text from that cell, like Bold, Color, etc?

For example, this formula on Sheet2 DOES show the data from Sheet1, but
NOT the formatting:

=Sheet1!B3

Thanks!--
rerhart
------------------------------------------------------------------------
rerhart's Profile: www.excelforum.com/member.php...foamp;userid=8138
View this thread: www.excelforum.com/showthread...hreadid=504147A formula cannot change any formatting. It can only return a
single value to the cell. You might be able to use Conditional
Formatting from the Format menu to accomplish what you want.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;rerhartquot; gt;
wrote in message
...
gt;
gt; How can I have a cell equal another cell AND also include the
gt; formatting
gt; of the text from that cell, like Bold, Color, etc?
gt;
gt; For example, this formula on Sheet2 DOES show the data from
gt; Sheet1, but
gt; NOT the formatting:
gt;
gt; =Sheet1!B3
gt;
gt; Thanks!
gt;
gt;
gt; --
gt; rerhart
gt; ------------------------------------------------------------------------
gt; rerhart's Profile:
gt; www.excelforum.com/member.php...foamp;userid=8138
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=504147
gt;
Formulas return values only.

Formatting is a seperate step using Paintbrush or manually.Gord Dibben MS Excel MVP

On Mon, 23 Jan 2006 13:16:38 -0600, rerhart
gt; wrote:

gt;
gt;How can I have a cell equal another cell AND also include the formatting
gt;of the text from that cell, like Bold, Color, etc?
gt;
gt;For example, this formula on Sheet2 DOES show the data from Sheet1, but
gt;NOT the formatting:
gt;
gt;=Sheet1!B3
gt;
gt;Thanks!