Functions to format within cells

[kualjo]

Has anyone ever written a UDF to add formatting - bold, italic, underline, etc. - within a formula? Something like ="I have " & BOLD("NO") & " idea." This would return "I have NO idea." I know Excel does not have these functions now (maybe someday), but it seems like it could be done. I've just had the thought, so I haven't really dug into it, but thought maybe someone else has already written something like this.

 

[Fluff]

You cannot do that with a UDF, it would have to be a macro & the cell value would have to be text, rather than a formula.

 

[kualjo]

Well, it was worth asking. Thanks.

 

[Fluff]

You're welcome.