computing
  • 0

Solved how to bold text in an excel formula

  • 0

 

I would like to Bold text that is inside a formula while running Excel 2007. Here is the formula.

=”Upon receipt by the undersigned for a check from XYZ in the sum of “&DOLLAR(‘G702′!E28,2)&” payable to “&’G702′!C13&” and when the check has been properly endorsed and has been paid by the bank upon which it is drawn, this document shall become effective to release any mechanic’s lien, stop notice or right the undersigned has on the job of “&’G702′!E3&” located at “&’G702′!E5&” to the following extent. This release covers a progress payment for labor, services, equipment or materials furnished to “&’G702’!C3&” through “&TEXT(‘G702’!I9, “mmmm dd, yyyy”)&” only and does not cover any retention or items furnished after said date. Before any recipient of this document relies on it, said recipient should verify evidence of payment to the undersigned.”

As far as I know, it can’t be done in a single cell without VBA and even then it would be troublesome.

The Characters object, which can be used to set the font style for specific characters in a cell that contains a text string, will not recognize text within a formula.

Not only won’t it recognize the value returned by the DOLLAR function, it won’t even recognize the text in your “sentence” because it’s not really text. The cell contains a formula that returns the text within the quotes; it doesn’t really contain the text itself.

So, in order for VBA to bold just the characters returned by the DOLLAR function, it would first have to convert the entire cell to Text via Copy…Paste Special…Values, then determine where the characters returned by the DOLLAR function start and end and then bold just those characters.

It’s doable, but you would lose your formula, which might not be a problem if the you are using is a template. Open the template that contains the formula, enter your values, run the macro and then save the sheet under a different name.

Of course, none of that matters since you don’t want to use VBA.

The only other option I can think of is to split your formula into multiple cells so that the DOLLAR function is in a cell by itself. Once that is done, you can simply bold that cell.

Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

 

Share

0 Answers

  1. This answer was edited.

    As far as I know, it can’t be done in a single cell without VBA and even then it would be troublesome.The Characters object, which can be used to set the font style for specific characters in a cell that contains a text string, will not recognize text within a formula.

    Not only won’t it recognize the value returned by the DOLLAR function, it won’t even recognize the text in your “sentence” because it’s not really text. The cell contains a formula that returns the text within the quotes; it doesn’t really contain the text itself.

    So, in order for VBA to bold just the characters returned by the DOLLAR function, it would first have to convert the entire cell to Text via Copy…Paste Special…Values, then determine where the characters returned by the DOLLAR function start and end and then bold just those characters.

    It’s doable, but you would lose your formula, which might not be a problem if the you are using is a template. Open the template that contains the formula, enter your values, run the macro and then save the sheet under a different name.

    Of course, none of that matters since you don’t want to use VBA.

    The only other option I can think of is to split your formula into multiple cells so that the DOLLAR function is in a cell by itself. Once that is done, you can simply bold that cell.

    • 0