For instructions on how to add a function to a workbook refer to the page under Inserting Functions

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.

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