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.
Step2: open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.
Step3: then the “Visual Basic Editor” window will appear.
Step4: click “Insert” ->”Module” to create a new module.
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.
Step6: back to the current worksheet, then run the above excel macro. Click Run button.
Step7: let’s see the result: