Extract data with specific font from cells with content in several lines

[vikassi]

Platform: Windows10

Excel version: MS Excel for 365 Apps (Version 2008)

Please see the attached excel sheet.

I am trying to read data that has font Green. Please note that a cell can have more than one lines and it is possible that only some lines in a cell are Green and other are default Black.

I have a user-defined function (in attached macro sheet) that reads a cell with multiple lines and extract only those lines that has font Green.

But the output comes in one line. Can you please help me to get the output in multiple lines in one cell?

Thanks, Vikas