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
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