Using Bold and Italic on certain text in formula

**pakida** · 03-05-2013, 08:18 PM

Hi ppl, what i've known so far there is no such things that we can put bold/italic to text which have formula. Is it? I knew that when i'm in the middle of excel project and its a lot things that I cannot return/start it back. So its disapointed me and bother me too much that might be complicated for me to find any solutions or ideas. I'm using CONCATENATE and formula that need to be fit with some forms. Can you guys hand me on this?

I accept any ideas or suggestions.

Thank you.

**dredwolf** · 03-05-2013, 08:27 PM

As far as I know, within a formula you cannot format they text in the ways you are asking...within a Text cell you can, just highlight the text to be formatted and apply formatting, the only way i can think of for formulas themselves is through VBA, and maybe not then even...sorry

The text displayed from a formula can be manipulated for bold/italic/underline/color through Format Cells and/or Conditional Formatting though...that may help

**shg** · 03-05-2013, 08:58 PM

Not even with VBA can you partially format the result of a formula while retaining the formula.

**dredwolf** · 03-05-2013, 09:13 PM

Didn't think so, but was not sure, Thanks shg

**pakida** · 03-06-2013, 02:36 AM

SO..should I give up on this? What do you think guys? Its already been 2 months ...

**shg** · 03-06-2013, 09:24 AM

What's your working definition of "can't be done"?

**pakida** · 03-08-2013, 03:20 AM

it's about time...

**dredwolf** · 03-08-2013, 03:35 AM

If you got a solution, I would LOVE to see it, I have applications for it myself ?

Plus, any solution posted can be searched & found by those willing to do the search

**Shazardred** · 05-20-2014, 04:43 PM

dredwolf, I'm not sure if you still need it, but I found a workaround for this.

I found this bulletin board thread which basically states you can use the .Characters property in VBA to bold/italicize specific text.

The syntax was a bit different for me, as I have Office 365, so here's how I coded it. First, a little bit of background about my workbook. I have a tab labeled 'VBA' which I use to store my variables so that when something goes buggy, it makes it quicker for me to find the source, track it down & fix it. For this particular problem I wanted to display two completely different blocks of text formatted completely differently depending on a single checkbox.

Then, I linked the CheckBox to a cell in my 'VBA' tab and created a simple CONCATENATE formula inside an IF statement which would display the target text depending on the value of the CheckBox.

Please Login or Register  to view this content.

Then, I had to determine where the starting & ending positions of the bold/italic would be. (Fortunately, the text I was bolding/italicizing went to the end, but you could modify the following formula fairly easily). Note: the 1st line of the following formulas went in one cell which I'll be referencing as CharBeg in a second, and the 2nd line went into a different cell referenced as CharEnd

Please Login or Register  to view this content.

Then, I put the following code in VBA (along with adding the Dim statements for the variables)

Please Login or Register  to view this content.

Lastly, I assigned the YourSubHere macro to the CheckBox, so whenever the CheckBox is checked/unchecked, the text in TargetRange (A33 for me) is automatically updated.

Hope that helps, and let me know if I can help further.

**6StringJazzer** · 07-27-2014, 07:53 PM

Originally Posted by shg

Not even with VBA can you partially format the result of a formula while retaining the formula.

Originally Posted by Shazardred

dredwolf, I'm not sure if you still need it, but I found a workaround for this.

The workaround provided by Shazardred converts the formula to a value before applying the formatting. That's a great solution if you indeed want to convert the formula to a value. shg's comment is still true.