bold

  1. 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"?
  2. 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.
  3. 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...
  4. 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...
  5. 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
  6. 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!
  7. 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...
  8. 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
  9. 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?
  10. 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...
  11. 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...
  12. 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...
  13. N

    Displaying alternate Words in BOLD in a Cell

    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 : "...
  14. E

    How to make bold a formula or part of text?

    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!
  15. B

    Code Help Needed-Make Top Border Bold when entering a letter in a cell

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

    Concatenate and Bold two columns

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

    Is it possible to bold c ertain items in a listbox?

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

    Output certain text in Bold

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

    Pasting a block w/o needing to update conditional formats...

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

    Conditional formatting; format the text sentence in parentheses in cells

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

Some videos you may like

This Week's Hot Topics

Top