Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
What's the best way to add a row and copy formulas and formats? | Excel Discussion (Misc queries) | |||
Custom Formats | Excel Discussion (Misc queries) | |||
How to have formulas and formats auto copy to new inserted rows | Excel Discussion (Misc queries) | |||
Formulas | Excel Worksheet Functions |