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