View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Cell=Cell to include formatting

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
wrote:


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!