Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format text as bold/italics/underline PROGRAMMATICALLY/formula???
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format text as bold/italics/underline PROGRAMMATICALLY/formula???
Only constant text strings can be rich text formatted. Formulas can't.
-- Regards, Tom Ogilvy "Nat Maxwell" wrote: 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format text as bold/italics/underline PROGRAMMATICALLY/formula
Thank you, Tom.
Are you aware of any future developments in that area planned by Microsoft, perchance? thx! "Tom Ogilvy" wrote: Only constant text strings can be rich text formatted. Formulas can't. -- Regards, Tom Ogilvy "Nat Maxwell" wrote: 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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format text as bold/italics/underline PROGRAMMATICALLY/formula???
On Tue, 27 Feb 2007 11:23:07 -0800, Nat Maxwell
wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format text as bold/italics/underline PROGRAMMATICALLY/formula
Thank you, Ron!
I wish I knew more about VB programming/macros to actually try out your recommendation :-( "Ron Rosenfeld" wrote: On Tue, 27 Feb 2007 11:23:07 -0800, Nat Maxwell wrote: 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format text as bold/italics/underline PROGRAMMATICALLY/formula
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. -- Regards, Tom Ogilvy "Nat Maxwell" wrote: Thank you, Tom. Are you aware of any future developments in that area planned by Microsoft, perchance? thx! "Tom Ogilvy" wrote: Only constant text strings can be rich text formatted. Formulas can't. -- Regards, Tom Ogilvy "Nat Maxwell" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TEXT(F2 "0,0") displays 1 as 01, & how to bold and underline in TE | Excel Discussion (Misc queries) | |||
Cannot bold, italicize or underline text - Excel hangs | Setting up and Configuration of Excel | |||
formatting (underline/bold/strikethrough) in comment boxes | Excel Discussion (Misc queries) | |||
bold italics or underline | Excel Discussion (Misc queries) | |||
Changing font size, bold and underline | Excel Programming |