bold

Hi I would like to Bold alternate words for eg Name : MR.EXCEL Country : USA Dim strName As String, strCountry As String, Dim mpStart As Long strName = "MR.EXCEL" strCountry = "USA" With Worksheets("sheet5").Cells(14, 1) .Font.Bold = False .value = "Name : "...

Hi! How to make bold a formula or part of text? Preferably via formula as I want to bold a part of a text or a formula, along with other text/formulas in a cell. Thanks!

I have a sheet that when I enter the letter B in column A I need the top border for that row to be bold from column A to column AL. Thanks for your help as always.

This is so stupid but I have been googling for ages and still can't figure out how I've done this before so I'm hoping someone can help! I have two columns - A and B. I want to join A to B into column C, but keep the format of column A bold. I'm sure the macro for this is straightforward but I...

I have a userform with a text field. Is it possible to bold certain items in a listbox based on the value entered in the text field? For example, I have a worksheet that contains the max capacity of each room. A list of rooms available for booking will be listed in the listbox. In the...

This formula shows the "ABOVE DUAL SHADES" text in a line on my worksheets. Is there a way to output that text in Bold. Thanks =IF(FINALORDER!$B25="ABOVE DUAL SHADES","ABOVE DUAL SHADES",IF(FINALORDER!$HD25="","",(FINALORDER!$HD25)&" - "&(FINALORDER!$D25)))

Hello, I need to make values in column B and C bold if the corresponding entry in column A is a "1". So a 1 in A makes B and C bold, for every row where that's true. The conditional format is using a formula, like: =$AS11=1 and applies to column B and C, like $B:$C The thing is, I need...

Hi, I have a file 7000 rows which contain text. There's more than one sentence in the cell. I would like to format text in a cell like; All sentences Bold, except in parentheses. Sentences in parenthses will be Italic-not bold. How can I formulate this issue and apply all rows? Please help...

Hi please can you help me, I have the cold below where I want the "comments" to be in bold, how do I do this please? I have tried the <B> in front of the comments but this didn't work. "Comments: " & Me.TextBox9.Value & Chr(10) & _

I have a sheet with data in range a1 to a6 of usernames. Then in range b1 to z1 I have data relating the users. This is currently a test workbook that I'm working out the code for a much larger workbook. I've created a selection change event macro which changes the font to bold and colour to...

I'm using Excel 2007 Hi All, I want to use VBA to check if a Pivot Table Field is bold. This is the code I am using: For iLoop = BottomOfPage To TopOfPage Step -1 For Delay = 0 To 20000000 Next Delay CellSelect = "A" & iLoop MsgBox CellSelect Range(CellSelect).Select...

Hello, I join a series of two cells together with a slash in between, such that the cell shows the two numbers as a fraction, such as below: C1=A1&"/"&B1 I'm wondering if it's possible to have the numerator be displayed in bold font, while the slash and the denominator are in regular font...

I am trying to figure out if a formula can be used to control the format of a cell For Example If C3 or F3 is populated, then, make the contents of B3 bold Is there a way of doing this?

Hi, I have 14 columns with Vlookup formula's in them, here's one for example: =IFERROR(VLOOKUP($B4,'Main Squad'!$A:$AM,MATCH(Sheet1!C4,'Main Squad'!$A$17:$AM$17,0),0),"") They all work fine, until i use the sort button in the table there in. When i click on the persons name to put it in...

Hi Excel define Bold as a variant. Yet the example below (from https://docs.microsoft.com/en-us/office/vba/api/excel.font.bold) Assigned True to Bold!! So why excel did not define Bold as a Boolean? It would make sense to be define as Boolean. Thank you. what does it mean a variant variable...

Hi! I inserted my code and added some comment. I hope that somebody can find the mistake. Function CountBold(WorkRng As Range) Dim i, xcount As Integer For i = 1 To Len(WorkRng) If WorkRng.Characters(i, 1).Font.Bold = True Then If WorkRng.Characters(1...

Hi, I'm helping a friend with a mass of text data that has been imported into Excel. The data is textual, consisting of bold text followed by unbolded, and forum help has shown me how to split bold from unbold. However, it now seems there are issues with the imported data, namely leading and...

Hi, Trying to help a friend with this problem: They have masses of essentially text data which is basically a specialist English to French dictionary. A cell contains both the English word(s) and the French equivalent, and he wishes to split this into two cells. Looking through the data it...

Wondering if someone might be able to help with creating a macro. I have various words in column A and when certain words are found I need the row bold when those words are found. So for example when words teacher, student, or class are find in column A then I need the row those words are found...

Hello everyone, I have a cell with several lines, i would like to search for "1º", and when find bold that whole line. I found a macro that finds a text and bold it: (But has a lot of uncessary stuff i don't need like input box and stuff., only need to find 1º and bold line ) Sub...