up vote 1 down vote favorite
share [g+] share [fb]

Suppose I have this formatted text in cell A7 of worksheet "myworksheet":

My bold and italic text.

I can get "My bold and italic text" to show up in a text box in a chart by setting the formula for the text box to this:

=myworksheet!A7 (Excel changes it to =myworksheet!$O$7.)

That will get the text, but it won't keep the bold and italic formatting.

Is there a way to preserve the bold and italics in this scenario?

link|improve this question
feedback

1 Answer

up vote 0 down vote

Formulas only reference the value of a cell, not the format data.

Unfortunately, there is no way for a formula to reference the formatting of a specific cell, you will have to apply that formatting to the cell, or copy and paste special (all using source theme) instead of referencing.

link|improve this answer
Conditional formatting might be applied as a solution, but this answer is correct, you can't link the format – datatoo Feb 3 at 6:34
@datatoo, what do you mean by conditional formatting? Would that be able to apply to part of the cell content (e.g. just a word or two), not the whole cell content? – supertrue Feb 27 at 3:36
that isn't possible. If all you need is a display of the cell, you might try after copying a cell Shift+Edit+PastePictureLink in the target. It will be an image not the actual content, which may not work for you. – datatoo Feb 27 at 17:57
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.