bold

hi guys I wonder if anyone has come up with a non-VBA solution to find and identify text in cells that are e.g. in BOLD or Italic font? A1 = THIS IS A test of the content A2 = 19 (i.e. it starts at the 19th character for Italic) A3 = 6 (i.e. it starts at the 6th character for BOLD) doable...

I have an excel file with a dozen of sheets, each of them containing a few decades of cells with text strings in greek. I need a code that will recognize a list of about 50 greek words in all sheets and will turn them into bold, no matter how many times they occur in every cell. I know that this...

Hi! I have used VBA to create a sumbold formula in a sales excel sheet i have. Basically i have a list of all revenue likely to book this week, which is manually made bold whenever something is booked. I have used the sumbold to work out break downs of whats been booked, however i would also...

Hello all, Maybe the title is a bit ambiguous but I'll try and break it down. I have a set of data, which so far is 100+ rows. I have 6 cells say ranging from A1:A6. I have used Conditional Formatting on that row of data so that it fills a colour when it has the lowest value cell. There may...

Hello, can anyone help me (if its even possible) to set range for other excel integrated functions, like MAX, LARGE,... in one row, but only where the values are bold? Is it even possible? I have a table where are 20+ columns and some of the values in a single row are bold. (the count of bold...

Hello, I am in need of the following: I need to find all the bold text in Column C starting at row 3 and go through till 1000 rows on a tab called "Requirements". Then Copy that text and paste it into another tab called, "Overview", but into a merged cell (which is C & D starting row 29 on...

Hi There, Please can someone assist me with VBA code for the following. I have printed my Age Analysis into Excel and want to sum up the Debit Balances and Credit Balances separately and only need to sum the totals which are formatted in Bold. I.E. sum column N if values are positive and Bold...

Hi all. So i'm working on automation a whole process and i'm stuck on a what I would think was a simple part but it's giving me trouble. I need to loop through a range in column A and if the cell has the same text as cell A1 then bold the text and set interior color to 15. When I run this it...

Hi, I recorded a macro to format a rectangle as green outline and then put the letter 'B' and make that 'B' bold. The recording yielded the following code. When I went to run that same macro it got stuck on this line: With Selection.ShapeRange(1).TextFrame2.TextRange.Characters(1, 1).Font.Fill...

i have a userform and would like to format a text bold when transferred onto the sheet. If o4.Value = True Then Cells(emptyRow, 9).Value = "1" ElseIf o5.Value = True Then Cells(emptyRow, 9).Value = "0" Else Cells(emptyRow, 9).Value = "N/A" <<<<< i want this enter Bold End If

This is a request to Rick Rothstein and Peter_SSs who created the following VBA script in another Thread to do with underlining key words in a cell range > I'm looking for a similar solution except I would like the "Words" sheet "Data" to be converted to Bold and Red text. My Sheet with the...

Newbie here. I have some code to sum groups of numbers and enter the result underneath each group. I can't figure out how to show the results in bold. Any suggestions please? For Each NumRange In Columns("G").SpecialCells(xlConstants, xlNumbers).Areas SumAddr = NumRange.Address(False...

I have 23 headings that I need to bold (and hopefully move left 1 column) that are currently the same format as the data cells they are among. I can find them manually, but these 23 headings occurs in each of 40 sheets of data, and I would like to not play hide and seek that many times. Is there...

Hello everyone, I have encountered the following scenario. I need to concatenate two cells into a third cell while adding a ": " to act as a divider between the two, in columns 1000 cells deep. I also need to make the divider and all text before it BOLD. I have been using the following code from...

See below screenshot. I need the output of a formula to bold particular words within the output. I have a very complex spreadsheet, but have used a simple example for clarity on whether or not is can be done without VBA/Macros. Thanks for the help!

I use this code to bold+red things in a column that need to be flagged (cells with values greater than zero) - - however, now I need to have the code simply locate anything that is > than 0 and TURN IT TO "0" while also making THAT item red+bold. Does anyone know an easy way to update this code...

So I've applied conditional formatting to columns A and B to highlight and bold any blank entries. However since those guys tend to show up a thousand rows or so down I don't have anything to alert me that there is a problem. I know that I can just filter those columns to check but I'm not the...

Hi all, I have some text that are Bold / Not Bold in one cell. I change the color of the cell and it looks fine. I save, close, re-open and the bold part has changed color. I have even tried to hard program so that it changes to my desired color at the end of my open procedure in VBA, but this...

hi all, i'm trying to have a macro run to search a specific column (S) for a particular text value "y" and if true it will change the font to bold and the color to red for the entire row of the cell that contains the "y". the column is part of a data table that is constantly refreshed not sure...

I would like it when a cell is selected it will make the text Bold and when you click it again it makes it back to normal ??