bold font

  1. A

    Put a variable in bold character in VBA

    Hello, I have a VBA sub sending an email with outlook. I am looking to have some parts in Bold characters. I thought of using .HTLMBody in the code based on some posts I saw. Where’s the catch? Well the parts I’m looking to put in bold characters are variables from a worksheet... I did...
  2. A

    Formatting 2 strings in cell in different ways

    I have 2 columns, Column A has a regularly formatted first name. Calibri 11. It is also a look up formula from another sheet. Column B is Surname which is also a lookup formula from another sheet but I have used the Upper function on it to make it all upper case and also bolded the column. I...
  3. JARHTMD

    How to format only a part of a formula in Excel2007

    Col M contains a keyed value for "trip segments". If the trip was made w/o stopping Col M = 1; one stop = 2; two stops = 3; etc M2 = " Stopped along route on "&(SUM(M17:M382)-COUNT(M17:M382))/COUNT(M17:M382)*100&"% of trips" That is not 100% accurate, but it's close enough. More than 1...
  4. S

    Formating range is causing phantom rows

    I have a workbook with a lot of subroutines that I've authored. I am having an issue with one of my subs taking way too long. For this investigation I used the Task Manager to track down the problem. When I start the sub(routine), Excel is using 100MB of memory, when it's finished Excel...
  5. H

    Making Groups in 'For Each' loop

    I am compiling a list of BOMs. It will first list the assembly name, and then list all of it's components in the rows underneath. The assemblies name and fields pulled with it must be bold. The list of components underneath it must be group together, so i can collapse all the groups and just...
  6. C

    Macro To Add Border If Font Is Bold

    Hi All, I was wondering if anyone knew of a way to write a macro that would add a top border to some cells in a selected range. All of my number data is columns I:O with subtotals every so often (example of columns F:O below): <TABLE style="WIDTH: 451pt; BORDER-COLLAPSE: collapse" border=0...
  7. C

    How to filter based on bold font

    Is there a way to filter based on whether cells contain bold font? I'm using Excel 2010. Thx in advance.

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top