1. M

    Counting Bold words in a cell with a Macro doesn't work right

    Hi! Years ago I asked for a macro for counting Bold words in a text inside a cell for something I was doing, and a user gave me that code below: Function nBold(cell As Range) As Long If cell.HasFormula Then Exit Function Dim tmp, n As Integer, x As Integer tmp =...
  2. L

    Formula to make cell text bold based on other cell value?

    I have the following formula already in a cell - =IF('Project Estimate'!A4=0, "", 'Project Estimate'!A4) It's working great by pulling data from another sheet. Some of this data will start with " - " before the text. Is there a way to add to the above formula, that if that cell its pulling from...
  3. L

    Macro Creation - Sort Rows, Add blank row, conditional format text

    I'm looking for assistance in setting up a macro to do the following. 1. Add a blank row in between each set of value from Column G. Column G is named "Handler (Job)" and may have different values on different tabs. Let's say it comes looking like this - Bob Susie Susie Lauren Bob Lauren...
  4. 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...
  5. 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...
  6. J

    Format bolded text only.

    Hi! First time posting here! I have been struggling with a very specific and probably weird issue that I am not sure of having a solution. The problem is related to text that is initially in word documents. Likewise, I have today asked for advice in a forum connected to Word VBA...
  7. J

    Concatenate cells but keep formatting of text from source cells

    I have been trying to concatenate cells from a different master sheet into one cell for a label. the problem is that some parts of the text are bold (for allergens) and when I finish it erases all the formatting from original cell. I've tried several different macros and nothing works. Please...
  8. G

    Making certain columns contain bold texts dynamically

    Hello there, I am a new member in this forum (just joined now). I am in my Excel learning journey and I hope that I can make contributions to this forum soon i.e., hoping to be active. Greetings aside, here is my problem. I wish to make a row of dates (not in columns which is usually the case)...
  9. F

    How do I get Excel to return a value based on the max value in a table?

    0 1 2 3 4 5 1 1 2 3 4 5 3 6 7 8 9 0 5 1 2 3 4 6 7 2 3 3 4 2 I have a table as such with rows and columns in bold. I know the max value within this table is 9. How can I get Excel to return "3" and "4"?
  10. M

    Changing a specific cell in a Named Range

    Is it possible to change a specific cell in a named range to Bold. Example My Nmaed Range "MyRange" Refers to A1:A5 (This range is dynamic so it changes based on other cell input.) What would be the code to change A2 in MyRange to bold.
  11. M

    IF statement to return a text string linked to conditional formatting

    Could you please advise if its possible to have an IF formula statement in cell B7 when two conditions are true, one of which is using conditional formatting (red bold text based on a formula condition in another validation cell)? <tbody> A B 1 NAME TITLE 2 Mark Manager 3 4 NAME...
  12. J

    VBA - Delete rows that DO NOT contain Bold font

    Hi there, I know this is a pretty easy one, but can't get this to work. I have a bunch of data rows and if all the cells are not Bold in a row, then delete the row (just delete within data range, not entire row). Otherwise, if there is a cell in the row that is Bold, then leave row as is...
  13. D

    Find 2 in a column and make it bold

    Hello I'm looking for a macro that will search column L in a sheet for number 2 and if it finds it then make that 2 bold, red and 18 point. Thanks
  14. S

    Find cells with value + conditional format...

    Hello, How do i find cells in any sheet in the whole book with value 0.09 and a conditional format that made the font bold? It's not normal bold apparently, because the built-in Find GUI doesn't find conditional bold.... Thanks!
  15. J

    Highlighting Cells with Conditional formatting

    i currently have a couple of tables on a workbook. i am wanting to use some conditional formatting that will highlight certain cells when a criteria is met and will change the highlighted cells when the criteria is changed. i am able to highlight one cell using conditional formatting, but is...
  16. R

    Macro to merge cells

    Hi all I would like to enter a value in a cell and have the 2 cells above and the 2 cells below all merge and increase the font size to 24 in bold. Example: A value is entered in A3. A1:A5 is merged. Font size increases to 24 in bold. Possible? Thank you! Russ
  17. A

    Concatenate and bold

    Hi, i am ccocatenating 2 columns that are I and J, and i want the test in column I to be bold. how can i do it?
  18. A

    conditional format closest values across three ranges

    Hi I have a bit of a challenging conundrum (for me at least!). Id like a conditional formatting rule to highlight the three closes numbers across the three columns, but with only 1 cell highlighted per column. So if my data was as follows, the closest 3 would be the ones in bold. (1 per...
  19. K

    Moving Bold items to other columns

    I have never created a macro in excel, and last night I was trying to and I created an IfBold Macro by reading on this website, however it did not really do I really needed to do. I would really appreciate any help I can get. I am this General Ledger Activity report that I need to convert to a...
  20. M

    How to bold a range value within a html string?

    Hi, I am learning how to use htm within .htmlbody. I pull a bunch of dynamic values and am wanting to make these bold. " PO Description: " & ""&Range("H" & (ActiveCell.Row)).Value&"&" & " " _ The "" works but the "" gives me an error. For some reason it refuses to accept my html coding. In...

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
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 "".
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