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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best file system for a 64gb micro-SDHC card? 5
MZ Tools: Where Does It Store User's Data? 10
Conditional formating 4
Sharing content between Media Center PCs? 1
Selection of records from subform to lock and further processing in access 2007 0
User state migration error............ 0
Adding Within Categories 1
Auto Text Question 2

Top