bold text

  1. A

    Is there a way to apply Conditional Formatting to JUST a number in a text string?

    So, in other words: I have cells that contain text strings. The text strings may or may not contain numbers. In the event that they DO contain numbers, I'd like to set up some way to automatically make JUST THE NUMBERS bold. \ Is this possible? Either via Conditional Formatting or VBA? Thanks!
  2. Nayasoch

    Find Bold letter and add ** Before and after each bold letter of entire paragraph in Word

    Hello guys I need help with Ms word, where I have entire paragraph....I am looking for any vba code to add ** before and after each bold letter...so far I have Sum AsteriskText() Dim keepSearch As Boolean keepSearch = False Selection.Tables(1).Columns(3).Select Do...
  3. D

    insert comment field - how to reset the default font, etc.

    insert comment field - how to reset the default font, etc. the 'insert comment' field defaults to a. font size = 9 b. bold how do I reset the default to something that I prefer?
  4. B

    Format Unlocked Cell on Protected sheet

    I am using excel 2003. I have locked and unlocked cell on the same sheet. I have protected the sheet. I can enter data into the unlocked cells. But I can't BOLD the text in the unlocked cells. Is there anyway to allow the user to bold the text in the unlocked cells in a protected sheet...
  5. A

    Partially Bold Valued Cell

    My data exist on one sheet, its takes time if i go and detect partially bold valued cells. I need a code which detects these cells and then insert some rows above it..... i need regular row difference in such cells. say the last value is asif and mext value is raza. i want the row difference...
  6. A

    Finding cells with values

    Hello All I am trying to write a macro which looks at the value in a cell, and if it is empty moves up one cell, and does so continuously until the active cell has a value, at which point it makes the active cell bold. I tried using the .Find method but that code did not stop at the first cell...
  7. K

    Concatenate 3 columns and retain bold format of contents of 1 column

    Does anyone know a VBA code that can concatenate contents of 3 columns with text cells while retaining the bold format of the contents of 1 column. I have a Range A1:A5 containing text of titles that are in Bold format and I wand to combine it with text of different last names in Range C1:C5...
  8. F

    Bold part of a text with a formula

    Hi there, I am struggling to get the code for bolding part of a text with a formula. My sentence is ="That the monkey ate all the appels dated "&TEXT(InRisk,"dd mmmm yyyy") The date should be in bold Please help

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

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
Top