bold

I am looking for a VBA code to bold cell contents of sheet 2 when they do not equal the contents of the same cell on sheet1. I was doing this with conditional formatting but when i run another macro it messes up the conditional formatting. I tried doing as much vba as i know with no luck. The...

Hello All, This works fine to give me a bolded header: With mySheet.PageSetup .LeftHeader = "&""Arial,Bold""&12" & headString End with Where headString is a string variable. I can change the word 'Bold' to 'Italic' and then I get an unbolded, italicized header...

I have the following code and want to make it run whenever any of the ranges change (specifically T5, T9, T13). I've tried multiple ways but none seem to work. The code works fine when I step through it but when I call it, it doesn't run (Refer to Below). Sub BoldPartText1()Dim Part1Len...

Hi everyone, I hope anyone can help me with this issue. I am not very expert on coding with VBA but I'm trying to search for a code that splits BOLD text from non bold text. All my texts are looking like this: 1: Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem...

Hey, I have this code. But I need to bold text from cell K14 and change color of cells K21-K25. How can I do that? Please help :( Sub SendMail() 'SendEmail Macro ' ' Dim outlApp As Outlook.Application Set outlApp = CreateObject("Outlook.Application") Dim outlMail As...

all this info would be entered into a table/array <tbody> R x 201 x 202 x 203 x R 506 508 x 510 x </tbody> and then i want to activate a button and check if the x is in the box then generate a whole new list/table/array and the out come will look something like this <tbody> R...

I need my spreadsheet to automatically insert a sequential number to all cells in column A (beginning with row 14) with the exception of the rows that contain bold text (header rows if you will, for each category). I also need to be able to add or delete rows and have the numbering auto correct...

I have a a weekly excel file that I need to add a blank row before Item Title. The title is always doen with a bold type face, is there a way to search for certain font criteria i.e. "BOLD" and have a new blank row inserted before that row? I look forward to your assiastance as I am trying to...

So I have this table, my goal is to remove the ones that are bold. The logic is to remove the rows which contain additional FALSE value, so I would end up with a FALSE, TRUE, FALSE, TRUE row. <tbody> False True False False False True </tbody> Why? I am scraping a site which has...

Hi, I am currently trying to create a VBA to show a cell value in the center header in bold, I have got the cell value to show in the header but I am unable to get this to go bold and font size 14? I have tried a few methods but none have worked? Code I use is below: Sub HeaderFromB19()...

Hello, I have a macro to find a range of cells and place a total below the last cell with data. I'd like it to put the sum in bold but I've only managed to get it to make the first cell with data bold. I also would like to add in some code to find the last cell with data in the A column and...

I want to Join two cell with "&" A1=13 and B1="Name" . when Join these two ,i want "Name" show Bold letter.

I have a spreadsheet where I want to count a range of cells that have bold text in them, I have done this through a function. However, when someone deletes the value in a cell that has a bold font, the cell still shows the font as being bold and the function still counts it even though it is...

I am looking for two very similar tools. I believe I would only need this to work in Column A. The first tool I am looking for is a macro that when activated will navigate the selection cursor to the next cell below that contains bold text. If you then activate this tool again, it will do the...

My spreadsheet is from Col A to Col O Some rows in Col C contain a number followed by the word Total (1234 Total). I want to bold the entire row for all that that contain the word Total. Below is macro I am using -- can someone tell me what I doing wrong? For i = 1 To Cells(Rows.Count...

Hello, I'm using the below VBA to send an email through outlook and was hoping I can get some help on how to bold the body of the email. All I'm finding is how to bold a portion of the body. I would like to bold all of the body. .To = Range("A82").Value .CC = Range("A83").Value & "...

Does anyone by any chance have a macro that can do the following? 1.) Call up a dialog box with a find (search) field 2.) User types in desired search for BOLD text items only 3.) Searches for and finds the first BOLD text item instance 4.) Closes dialog box automatically 5.) Navigates cursor...

Hi Guys; I need some expert help...Please I have a program here that will search through a specific "Range" of data for a single word and format that word accordingly. This program works fanatically if I'm just searching for a word or two b/c this program provides a "pop-up" box for...

Hello! I'm trying to set conditional formatting on column H cells where the cell in column A is blank. So if A5 is blank, H5 should be in bold; if A6 contains a value (in this case, a date), then H6 should not be bold. I've tried the following formula for H:H... =IF($A5="",TRUE,FALSE) ...but...

I am working with a spreadsheet and I need a little support. In Column D I would like to find any text that is bold, copy that text, and then paste it into Column C. If possible, I would then like to delete the bold text from Column D. Any ideas on how to make this work?