Monday, 8 July 2013

How to filter cells by bold characters in Excel?

There could be various methods, here is one of the easiest and simple method using VBA

Step 1: Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Application window.

Step 2: Click the Insert >> Module, and paste the following VBA code on the new Module window:

Function IsBold(rCell As Range)
IsBold = rCell.Font.Bold
End Function

Step 3: In the Cell D2, enter the formula of =IsBold(B2), and press the Enter key. If the string in Cell B1 are bold, it returns True in Cell D2, otherwise False.

 

No comments:

Post a Comment