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

[vikassi]

Please see the attached excel sheet snapshot.


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. For example:

Can function return as shown in following snapshot?

Would appreciate help!


regards, Vikas

 

[Fluff]

Hi & welcome to MrExcel.
It would help if you posted your current code.