Multi-line cell formatting

[Guest]

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

 

[Tom Ogilvy]

Turn on the macro recorder and manually apply the bolding to a subset of the
text as you describe. Turn it off.

This will show you how to use the characters class/method to do what you
want.