How to find cell values ​​with bold font?

Question

excel

You need to select the cell values ​​to be copied to another sheet of the document by linking to the cell with bold font. On one site I found the following formula: =FOLD(A2), but I don't have such a formula in excel. How can you do?

Answer 1

Try to read the information on the site to the end, it will be below:

Function ЕЖИРНЫЙ(ЯЧЕЙКА As Range) As Boolean
  ЕЖИРНЫЙ = ЯЧЕЙКА.Font.Bold
End Function

upd
1. Open the Excel file
2. Press Alt+F11
3. Create a new module

spoiler

4. Paste the code

spoiler

5. And then use it as a regular formula

spoiler