Transporting from one sheet to another

C

Colin

When transporting text from cells in one work sheet to cells in another,eg
( =+goods!B17) is there a way of transporting the text as bold text?
 
C

Chip Pearson

No. A formula link can return only the value of a cell, not the
formatting.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
R

Rick Rothstein

If you select the cell where your =goods!B17 formula is located (you don't
need the + sign by the way) and use Format/Cells to make its font bold, then
the results of the formula will be displayed bold. This is an all or nothing
solution, though... that is, all results of the formula will be bold, not
just some of them.
 
Top