Can formats follow formulas?

  • Thread starter Thread starter Phrank
  • Start date Start date
P

Phrank

Hello,

I have a worksheet with many formulas connected to a second sheet.
Some of the formulas on the first sheet are simply 'reading' the
contents of a cell on the second sheet. However, if the contents of
the cell on the second sheet has some specially formatting (i.e.
bolded, italicized, etc.), the formatting doesn't follow to the first
sheet. Is there a way to make this happen? Thanks.

Frank
 
No, formulas can never carry formats

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
Well darn, that's not what I was hoping to hear. Thanks though. Can
you think of a 'work around'? I have two identically looking sheets,
and one is for entering the data, and the other manipulates the data
and is the 'presentation' sheet. Thanks.
 
You must log in or register to reply here.

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

Update cell value based on name and specific date 1
Dependent drop down dynamic range formula, off sheet. 7
Vlookup and return sheet name also 2
Excel A CountIF question... I think 2
Formatting does not follow when copying from one cell to another 6
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Excel Import Comments 3
using the =page! feature to transpose a row to column 0

Back
Top