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 |
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 |
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 |
All times are GMT +1. The time now is 05:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com