How to Filter Cells with Bold Font Formatting in Excel

This post will guide you how to filter cells with bold font formatting in Excel. How do I filter cells with bold font formatting with VBA Macro in Excel 2013/2016.

Filter Cells with Bold Font Formatting


Assuming that you have a list of data in range B1:B5, in which contain text values, and you want to filter those cells with bold font formatting, how to do it. You can use an Excel VBA Macro to accomplish it. Just do the following steps:

Step1: select the range that you want to filter cells with bold font.

filter cells with bold font1

Step2: open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.
Get the position of the nth using excel vba1

Step3: then the “Visual Basic Editor” window will appear.

Step4: click “Insert” ->”Module” to create a new module.
export each sheet to csv2

Sub FilterBoldFormatting()
    Dim mycell As Range
    For Each mycell In Selection
        If mycell.Font.Bold = False Then
            mycell.EntireRow.Hidden = True
        End If
    Next mycell
End Sub

Step5: paste the below VBA code  into the code window. Then clicking “Save” button.

filter cells with bold font2

Step6: back to the current worksheet, then run the above excel macro. Click Run button.

filter cells with bold font3

Step7: let’s see the result:

filter cells with bold font4

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar