It is possible but this does not seem like a good design to me. It is not practical to do any analysis when you are putting more than one data item into the same cell. I would recommend you enter this data on separate rows.
How are you entering data? If you are using ALT+ENTER to force a line break in the cell, and the first line of text is always what is bolded, it is possible for VBA to do that. You would put this code into the module for Sheet1 (or whatever worksheet). You would also have to refine it to limit the action to the cells containing this type of data.
Bookmarks