Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phrank
 
Posts: n/a
Default Can formats follow formulas?

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Can formats follow formulas?

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


"Phrank" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phrank
 
Posts: n/a
Default Can formats follow formulas?

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.

On Thu, 8 Jun 2006 20:37:27 -0700, "Peo Sjoblom"
wrote:

No, formulas can never carry formats

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please help with Statistics Formulas in Excel Fonz Excel Discussion (Misc queries) 10 April 9th 06 03:22 PM
What's the best way to add a row and copy formulas and formats? Michael at Sigcon Excel Discussion (Misc queries) 1 March 17th 06 02:43 PM
Custom Formats centerNegative Excel Discussion (Misc queries) 3 October 7th 05 05:01 PM
How to have formulas and formats auto copy to new inserted rows DippyDawg Excel Discussion (Misc queries) 2 August 5th 05 03:09 PM
Formulas Stan Excel Worksheet Functions 3 January 21st 05 02:58 PM


All times are GMT +1. The time now is 11:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"