How to find out a large number of cell addresses in an Excel spreadsheet?

Question

excel

Hello, for several days I have been suffering to find out the addresses of all black cells, since there are 5095 of them here, and it’s a pipets to write each one down, also if you find them by format, it does not allow you to copy the addresses of the found cells. In general, if someone knows how to quickly find out the addresses of all cells, and copy them, please write!

Answer 1

Do you want formulas?
I would not. Macro is better.

Answer 2

The fastest option is a VBA macro with a search by format and iterate over all found cells. The resulting data can be saved in the desired format.