On Fri, 25 Dec 2009 10:26:01 -0800, Gary
wrote:

Also, is it possible to bold and underline within a TEXT function?

No. But more particulars might help solve your problem.

You can bold and underline the entire cell either as a "hard" format or with
conditional formatting.

You can also put an equivalent of your TEXT function into a VBA Macro, and then
bold/underline a portion of the text string that you would have your macro
write to the cell.
--ron