While there is no direct way to filter cells with text in Bold font formatting in Excel, you can easily do this.

In this video, I will show you three ways to filter cells with text in bold font formatting:
-- Using Find and Replace
-- Using Get.Cell function
-- Using Custom Function made with VBA

With Find and Replace, you can find all the cells that have a specific format in it. So you can specify the bold font format and Find and Replace will find all the cells with it.

Now you can replace this format with one that colors the cells with the specified color. Once the cells have the background color, you can easily filter these using the Filter by Color option.

GET.CELL is a Macro4 function. While you can not use it in the worksheet, you can still use it in named ranges in Excel. Once you create this named range, you can use it to get TRUE for all cells that have cells with text in bold font format. Now you can filter these cells and you will also have filtered the one with bold font format.

The VBA custom function works the same way. The formula returns TRUE when the cell has text in bold font format and FALSE when it doesn't. Now you can filter the cell with TRUE.


Read More: [ Ссылка ]



Let's Connect:
Google+ ► [ Ссылка ]
Facebook ► [ Ссылка ]
Twitter ► [ Ссылка ]
Pinterest ► [ Ссылка ]
Youtube Channel ► [ Ссылка ]

Filter cells with bold font format, Filter cells with bold text, Filter cells with Text in Bold Font Format #Excel #ExcelTips #ExcelTutorial

свернуть