Make part of a cell Bold using a formula??

I have a formula that combines the the text of various cells.

Is there a way to automatically make part of the cell Bold - so in this case I want the Cell B13 to appear in bold.

See formula below:

Please Login or Register  to view this content.

Thanks for you help.

Good morning Neil07979

Originally Posted by Neil07979

Is there a way to automatically make part of the cell Bold - so in this case I want the Cell B13 to appear in bold.

No.

It is not possible for any function to alter formats at all. That also extends to UDFs.

HTH

DominicB

Nope. Only flat text cells can be multi-formatted in this manner.

I'll be very interested when you remember how to prove us all wrong.

If you did it four years ago, you did it in an Excel workbook. Locate the workbook(s) and you'll have your answer. Meanwhile we assert this is not possible via formula.

Not possible via VBA either if the cell contains a formula.

I wish I still had access to that Workbook. It was during my Finance/Reporting internship at Kaiser Permanente's NW headquarters, and all reports contained private or proprietary info.

I guess I'm on a mission now to find how to do it. The funny thing is that when I originally searched for it, it's because I had seen it used in another dashboard report. I remember that the google search that turned it up was something like "Bold part of an Excel formula without VBA macro". The forum thread that I eventually found said, "I know there's a way to do this so don't tell me VB is the only way!" A few responses down was the answer. I wish I could find that thread again!

Something promising is that the TEXT() function allows you to do this:

=TEXT(H5,"$#,##0.00_);[Yellow]($#,##0), and the () will actually appear around the negative number, and it will drop the decimal ...but the yellow just doesn't show up. (but yellow does work in the custom format option for formatting the cell).

Still not what you're looking for, but the way I've managed this in the past is to carefully align text in several adjacent columns with the key "red" data in a cell of it's own for red formatting.

http://screencast.com/t/IcL3obWk0NHl

Exactly. The TEXT formula does not allow font colour changes. Even custom format codes don't allow you to bold a cell and the TEXT function has less functionality than those codes, not more. I will cheerfully eat my hat if you prove me wrong but, in the meantime, your recollection is faulty.