Function ISBOLD(cell As Range) As Boolean 
   If cell.Font.Bold Then ISBOLD = True
End Function

Returns TRUE if the cell is bold or FALSE if it isn't.
If you afterwards change the bold setting in the cell, you have to press Ctrl+Alt+F9 to have the formula recalculated.
This function does not recognize formatting if it is applied via conditional formatting.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext