Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-line cell formatting
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. -- Regards, Tom Ogilvy "Tim H." wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multi line cell | Excel Discussion (Misc queries) | |||
Concatenate: Multi-Line Cell with 2 single line cells | Excel Worksheet Functions | |||
Formatting multi-line text | Excel Programming | |||
Multi-line Formatting | Excel Discussion (Misc queries) | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) |