I have VBA code that uses a list of tasks from one sheet to populate a
calendar type view on another sheet.  Each calendar day (cell) shows that
corresponding tasks for that date, each separated by a CR/LF.  For example,
one cell may have 5 lines representing a mix of open and completed tasks. On
the calendar sheet open tasks are currently shown preceeded by "o-" and
completed tasks are currently shown preceded by "#-". I would like to
differentiate completed and open tasks by showing open tasks in bold-face
font.  

I am having trouble writing logic that, following the generation of the
calendar entries, would allow me to interrogate each cell and only bold the
line(s) in the multi-line cell representing completed tasks.  I have tried
replace logic, but this does not retain the two possible (bold and non-bold)
conditions for the multi-lines.

Any thoughts would be greatly appreciated.

Thanks,
Tim