How to bold text in Excel formula

0computingAsked: September 3, 20212021-09-03T02:00:43+00:00 2021-09-03T02:00:43+00:00In: MS/PC-DOSSolved how to bold text in an excel formula0I would like to Bold text that is insi

How to bold text in Excel formula
computing
  • 0
  • computingAsked: September 3, 20212021-09-03T02:00:43+00:00 2021-09-03T02:00:43+00:00In: MS/PC-DOS

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 mechanics 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 cant 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 wont it recognize the value returned by the DOLLAR function, it wont even recognize the text in your sentence because its not really text. The cell contains a formula that returns the text within the quotes; it doesnt 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 CopyPaste SpecialValues, then determine where the characters returned by the DOLLAR function start and end and then bold just those characters.

Its 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 dont 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.

  • 0 0 Answers
  • 5k Views
  • 0 Followers
  • 0AnswerShare
  • Facebook

0 Answers

  • Voted
  • Oldest
  • Recent

Best Answercomputing2021-09-03T19:58:02+00:00Added an answer on September 3, 2021 at 7:58 pmThis answer was edited.

As far as I know, it cant 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 wont it recognize the value returned by the DOLLAR function, it wont even recognize the text in your sentence because its not really text. The cell contains a formula that returns the text within the quotes; it doesnt 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 CopyPaste SpecialValues, then determine where the characters returned by the DOLLAR function start and end and then bold just those characters.

Its 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 dont 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
  • Reply
  • ShareShare
  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn
  • Share on WhatsApp

Video liên quan