I want to bold first and last lines of text within cells.

**mIxe** · 05-22-2013, 04:57 AM

Greetings,
I want to bold first and last lines of text within cells.
Data inside cell are dynamic.
Is there any way to realize this task with Conditional Formatting formulas?
Any help on this matter would be appreciated …

**Pete_UK** · 05-22-2013, 05:22 AM

You would need to do this with a macro, as Conditional Formatting applies to the whole cell, not just parts of it.

Hope this helps.

Pete

**mIxe** · 05-22-2013, 05:37 AM

Thanks for your response on this matter.

**Fotis1991** · 05-22-2013, 05:48 AM

I don't know how your data looks like but one possible solution could be, to use 2 formulas to extract the first and the last word of your string to next columns..