How to bold a single word in a text string that appears in an excel IF statement

[BobWald]

Hi all

How do I bold a single word in a text string that appears in an excel IF statement.

For example: IF(A1=1, "apples and oranges", "potato and carrots")

Thanks for all help

BobWald

 

[Rick Rothstein]

How do I bold a single word in a text string that appears in an excel IF statement.

For example: IF(A1=1, "apples and oranges", "potato and carrots")

I am afraid you cannot do that... a formula and its output must have the same font characteristics for each character in the entire text string. There is a way to simulate what you want using VBA Change event code, but that would mean removing the formula completely and letting the event handler perform all the functionality of the formula in code.

 

[mfexcel]

For your reference
Format part of a formula result… A workaround (non-VBA) solution | wmfexcel

It's not perfect; and not effective if you are working with many formulas.

 

[Rick Rothstein]

For your reference
Format part of a formula result… A workaround (non-VBA) solution | wmfexcel

It's not perfect; and not effective if you are working with many formulas.

Please check your blog's spam folder... I just tried to post a comment to one of your other articles (once from my desktop and again from my laptop) and neither is showing up in the comment area of article. I have had this problem with other blogs as well... for some reason, certain blog software sees my comments as spam.

 

[mfexcel]

Rick, thank you so much for your comment. It's really my pleasure to have you commented on my blog.
Yes you are right. You comments somehow go to the SPAM folder, which I have already unSPAM.

Please check your blog's spam folder... I just tried to post a comment to one of your other articles (once from my desktop and again from my laptop) and neither is showing up in the comment area of article. I have had this problem with other blogs as well... for some reason, certain blog software sees my comments as spam.