Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping source formatting from a referenced cell.
I have a report that I reference definitions from a different worksheet
within the report. On the definition sheet, I have the word being defined in bold and the actual definition non-bold. However when I reference it from another worksheet excel only allows me to have it all bold or no bold. I've tried to "keep source formatting" to no avail. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping source formatting from a referenced cell.
Formulas return values--not formats.
Can you copy and paste instead? Nelson B. wrote: I have a report that I reference definitions from a different worksheet within the report. On the definition sheet, I have the word being defined in bold and the actual definition non-bold. However when I reference it from another worksheet excel only allows me to have it all bold or no bold. I've tried to "keep source formatting" to no avail. Any help would be appreciated. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping source formatting from a referenced cell.
A formula cannot affect the formatting of a cell.
Pete On Aug 26, 1:55*pm, Nelson B. wrote: I have a report that I reference definitions from a different worksheet within the report. *On the definition sheet, I have the word being defined in bold and the actual definition non-bold. *However when I reference it from another worksheet excel only allows me to have it all bold or no bold. *I've tried to "keep source formatting" to no avail. *Any help would be appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping source formatting from a referenced cell.
I could, but I have many reports referencing these definitions, and my hope
was to be able to make one change and have all the other reports update. Copying and pasting is certainly a possibility, but more time consuming. Thanks for the reply. "Dave Peterson" wrote: Formulas return values--not formats. Can you copy and paste instead? Nelson B. wrote: I have a report that I reference definitions from a different worksheet within the report. On the definition sheet, I have the word being defined in bold and the actual definition non-bold. However when I reference it from another worksheet excel only allows me to have it all bold or no bold. I've tried to "keep source formatting" to no avail. Any help would be appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Always keeping source formatting when copying and pasting in Excel | Excel Worksheet Functions | |||
Keeping data once referenced workbooks are closed. | Excel Discussion (Misc queries) | |||
The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
Keeping Source Formatting with Paste Link and VLOOKUP | Excel Discussion (Misc queries) | |||
Combining Cells BUT Keeping source formatting | Excel Worksheet Functions |