Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked text formatting
The issue I'm having is formatting of linked text. I'm not even sure if this is possible using excel. I have 3 worksheets within a workbook. One sheet has a few hundred cell full of text that I can move around. A second sheet links the data utilizing the following formula: =INDIRECT("data!b2") to the third sheet. The reason I need to do the indirect data link is to maintain cell references. I need to move the text around but keep the cell references the same. What I'd like to do is format the text in the first sheet (bold, italics, color, etc) and have this formatting appear on the final sheet. Right now when I format the text, it doesn't appear on the final sheet. I'm not sure if this is even possible in excel but I figured if it were, someone here would probably know. Thank you in advance for any assistance you can offer. -- vman252 ------------------------------------------------------------------------ vman252's Profile: http://www.excelforum.com/member.php...o&userid=17612 View this thread: http://www.excelforum.com/showthread...hreadid=521432 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked text formatting
You have a response to your post in .excel.
vman252 wrote: The issue I'm having is formatting of linked text. I'm not even sure if this is possible using excel. I have 3 worksheets within a workbook. One sheet has a few hundred cell full of text that I can move around. A second sheet links the data utilizing the following formula: =INDIRECT("data!b2") to the third sheet. The reason I need to do the indirect data link is to maintain cell references. I need to move the text around but keep the cell references the same. What I'd like to do is format the text in the first sheet (bold, italics, color, etc) and have this formatting appear on the final sheet. Right now when I format the text, it doesn't appear on the final sheet. I'm not sure if this is even possible in excel but I figured if it were, someone here would probably know. Thank you in advance for any assistance you can offer. -- vman252 ------------------------------------------------------------------------ vman252's Profile: http://www.excelforum.com/member.php...o&userid=17612 View this thread: http://www.excelforum.com/showthread...hreadid=521432 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grayscale conditional formatting of text | Excel Discussion (Misc queries) | |||
Formatting Cell to text | Excel Discussion (Misc queries) | |||
How do I apply conditional formatting to a text box | Excel Worksheet Functions | |||
How can I force certain text formatting in a cell? | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |