underline

  1. T

    Underline a Specific Text in a Formula

    I am trying to underline a text in a formula for a Construction contract application. See formula below: ="Paragraph b hereof, for the construction of the Project: "&Input!C2&", "& Input!C4&", "&Input!C5&" in accordance with the contract dated the "&Input!C31&" , between Owner and...
  2. Jyggalag

    How to make email text bold/underline with HTML.Body in VBA?

    Dear all, I currently have this code: However, it seems that me highlighting it with bold and underlining it through the use of "<b><u>" (which has worked for me before), does not work anymore. Does anybody have any idea how I can either fix or change my code? It would be greatly...
  3. Jyggalag

    Can somebody help me test my VBA code and fix it if it does not work?

    Hi all, I have this VBA code to write an email body text: eBody = "Dear person," & "<BR><BR>" eBody = eBody & " 1Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text (Text text...
  4. A

    Looking to make custom Ribbon buttons

    Any really for idiots guide to making custom Ribbon buttons? I'd like one that toggles between "Center Across Selection" on and off. Another that toggles through Plain, Underline, Single Accounting Underline to ideally replace the underline button. Is this possible? I downloaded the...
  5. F

    Format part of cell with underline

    Is it possible to format half of a cell with a different format? I'm using =TEXT(G5,"0.00")&CHAR(10)&TEXT(E5,"0.00") and would like to format the first half with an underline so it looks like a division. Like this 1267.98 66.21
  6. D

    How to Underline or Highlight Spelling Errors in Excel

    How can I underline or highlight spelling errors as I am entering text data ? Can I do this without a script? If so please tell me how. If I need a script THANK YOU IN ADVANCE if you would kindly share it with me. Thanks
  7. Jeffrey Mahoney

    Padding Number Format with Spaces

    Is there a number format or conditional formatting that can pad any alphanumeric value with spaces? I create a lot of Excel Forms. I want the empty cell to display as underline and I want the underline to show the full width of the cell. I know I can put spaces in the cell and it will show...
  8. K

    if statement with an underline

    How do I write an if statement that says if cell d10 doesn't match cell d9, then underline the entire row, then go to the next cell until there is nothing in a cell.
  9. O

    Custom format the selected cell using conditional formatting..

    Hey all, I would like to underline the value in selected cell using conditional formatting along with Application.Calculate method. I have achieved this with formatting the row and column with formula's such as =COLUMN()=CELL("col") =CELL("row")=ROW() =$A$1:$DZ$1 =$A$1:$A$600 respectively...
  10. Fergus

    Underline a worksheet

    I have a very simple VBA sub which is intended to underline a worksheet at each page break when printed. The total length of the worksheet is 3574 rows. The sub works fine down to row number 1477 but then gives an error message "subscript out of range". I have used this in the past on Excel 2007...
  11. J

    VBA loop for next

    In Column B is a concequtive list of numbers from 1000000 to 7000000. Want to insert a underline border in column A to H the first time the number is above 3999999. (This is part of a vba formatting mode) Column B is a list of account numbers. Not sure the specific account 3.999.999 exists...
  12. J

    VBA code formatting based on criterion

    In column C is a list of account numbers. After account 4999999, I want to insert a thick black underline from column B to K. Is it possible to write VBA code for this.
  13. H

    Format word wrap/breaks to appear as separate row in sheet

    I have an excel sheet that is exported from an access report. The excel file automatically resizes columns and wraps text, etc. One of the columns on this sheet contains about a paragraph's worth of information. My question is: is it possible to somehow format all cells in this (or all)...
  14. D

    Underlining Entire Phrase

    I have a cell containing a paragraph of text. When I go to underline a portion of that text, only the words are underlined and not the spaces. Is there a way to underline the entire phrase instead of just the words? What it does: The quick brown fox ran and jumped over the white fence. What I...
  15. P

    Excel custom format a value with bold and underline

    The formula is ="Total: " &SUM(B2:B10) Can you make the result appear bolded and underline. Just the result from the =SUM formula not the text Total.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top