Thread: Selectively referencing formatted text (bold cells) from one sheet to another

I don't think there's a native excel function that will allow you to do that. If you're willing to use VBA here is an example of code that will do what you're looking for. This assumes that the bold cells are in column A.

Sub CopyBoldRows()
    Dim rRow        As Range
    Dim sSelection  As String
    
    For Each rRow In Range("A2", Cells(Rows.Count, 1).End(xlUp))
        If rRow.Font.Bold Then
            sSelection = sSelection & IIf(sSelection = "", "", ",") & rRow.Row & ":" & rRow.Row
        End If
    Next
    
    Range(sSelection).Select
    Selection.Copy Sheet2.Cells(Rows.Count, 1).End(xlUp).Offset(1)
End Sub