bold

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

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

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

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

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

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

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

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

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

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.

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

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

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

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!

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

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

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?

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

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

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