Format text as bold/italics/underline PROGRAMMATICALLY/formula???

[Guest]

Hi all,
I have a text compiled in a cell as a result of a complex formula. I want to
be able to format PARTS of the resulting text (i.e., after the formula in a
cell compiles and displays the resulting text) as bold and parts as italic
and yet other parts as underlined.
Is there any operator I can insert into the formula so that the desired
parts of the resulting text are displayed as formatted?
Would gretly appreciate any assistance.
thank you!

 

[Guest]

Only constant text strings can be rich text formatted. Formulas can't.

 

[Guest]

Thank you, Tom.
Are you aware of any future developments in that area planned by Microsoft,
perchance?
thx!

 

[Ron Rosenfeld]

Hi all,
I have a text compiled in a cell as a result of a complex formula. I want to
be able to format PARTS of the resulting text (i.e., after the formula in a
cell compiles and displays the resulting text) as bold and parts as italic
and yet other parts as underlined.
Is there any operator I can insert into the formula so that the desired
parts of the resulting text are displayed as formatted?
Would gretly appreciate any assistance.
thank you!

You would have to replace the formula with its textual result. Not knowing your
requirements, this is something you could probably do with a Sub routine. And
you could include in that routine the decision making necessary to decide the
font variations for the different segments.
--ron

 

[Guest]

Thank you, Ron!
I wish I knew more about VB programming/macros to actually try out your
recommendation :-(

 

[Guest]

It is asked so infrequently, I doubt it would attract much interest from
microsoft and I suspect it would eat up a lot of development time and
processing power.