Linked Cell 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.

A formula cannot apply or change a format - you would need some VBA
code to do that. You would need to be more specific in your description
if you wanted a macro to do this.

Hope this helps.

Pete

Thanks Pete,

I was afraid that it wasn't possible. I looked as if the formatting was lost after the formula reference.

To offer more explaination in hopes that there is code out there that can assist me.

I have 3 worksheets within one workbook.

Sheet 1 we'll call the "final_sheet". This is the final report that I print out. It has all the colors and borders and cell ocation where I want them for printing purposes. All the cells have a reference located in them that points to sheet 2 (reference sheet). An example of the formula contained within sheet 1:
=reference_sheet!$C3

Sheet 2 we'll call the "reference_sheet". This sheet only has the indirect references. An example of the formula is: =INDIRECT("data!C3")

Sheet 3 we'll call the "data" sheet. The data sheet has the accual writen text that I want to have appear in the Final Sheet 1.

The text in the Data sheet (3) is always the same (unless I want it changed) but the location where I want that text to appear in the Final Sheet (1) is always changing. Due to my indirect cell referencing, I can move the data in the Data (3) sheet and have that text change location in the Final Sheet (1). I can have this text moved without having to recreate the Final Sheet (1) or re inserting new cell references.

I'd like to format the text in the Data (3) sheet (bold, italic, etc) and have that formatting appear in the final sheet. I cannot format the Final Sheet (1) because the information (text) will always be in a diffrent location within the final sheet (1).

If a formula cannot transmit formatting then I am supposing this formating change cannot be done. If anyone knows how to make a macro that can do this I would be very interested to learn.

Thank you in advance for any assistance,

Vaughan