Identifying boldface cells

Edit: I was not clear on whether you are looking for an Excel worksheet function, or a VBA function. The following description creates a user-defined function to use in a worksheet. If you are concerned only with VBA code, you can see from the code below how to determine if a cell has bold text.
==

Excel does not provide built-in support for determining format attributes of a cell, but this can easily be written as a user-defined function in VBA.

You can install the following function into your file:

Please Login or Register  to view this content.

It will return TRUE if the cell format is bold and FALSE if not. It will return FALSE if the range provided has more than one cell.

You use it something like this:

=IF(IsBold(A1),"The cell is bold","The cell is NOT bold")

Beacuse we're in a Programming forum I assume you know how to install the code but if not let me know and I'll post additional instructions.

Coding Lesson #37: You do not need to compare the value of a Boolean expression to True or False. The Boolean is already True or False, so you do not need to add a comparison on top of that which will evaluate to True or False.

In this example you could use:

Please Login or Register  to view this content.

Doing the comparison doesn't really hurt anything (a good compiler probably optimizes it out) but it's considered more elegant style to omit it.