Excel: to get the row number of the bold cell

Hi,
I want to extract the row number or value of cell A{row number} for the bold cell.

Ex. I want to extract or read the cell- banana by getting the row number (here I know it’s 3) because the upper highlighted(bold) cell value for bool column belongs to the row 3

Hi @Ray_Sha1,

Not done this before personally, but this forum post might help you. I imagine if you can get text colour, you can get other forms of text formatting.