The other day I wanted to show only bold cells in an Excel worksheet. Excel don' have a built-in formula for this. Using VBA to make one is very easy.
In Excel 2013 I had to bring the Macro dialog box (Alt + F8)
Give some random name in the macro name field (sdkfsdkf)
Click create (or Alt + C)
This will open the Microsoft Visual Basic for Applications editor, completely remove whatever is auto-generated in the module and paste the above code.
Then use the formula =IsBold(cellreference) to get a TRUE FALSE value. Later I used it to show only bold rows.
[How to filter cells by bold - Extend Office]
Function IsBold(rCell As Range)
IsBold = rCell.Font.Bold
End Function
In Excel 2013 I had to bring the Macro dialog box (Alt + F8)Give some random name in the macro name field (sdkfsdkf)
Click create (or Alt + C)
This will open the Microsoft Visual Basic for Applications editor, completely remove whatever is auto-generated in the module and paste the above code.
Then use the formula =IsBold(cellreference) to get a TRUE FALSE value. Later I used it to show only bold rows.
No comments:
Post a Comment