Linked Cell Formatting

[vman252]

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.

 

[Pete_UK]

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

 

[vman252]

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