How do I highlight different lines within the same cell two different colors?

In EXCEL 2007 take the following actions:-

1. Click in cell C3 (for example)

2. Insert / Illustrations group / Shapes / click on Line / draw it in cell
C3 / DrawingTools group / Format / Shape Styles group / Shape Outline / click
the colour that you wish to have for the line.

3. Repeat step 2. for your second line but change the last step to a
different colour.

If my comments have helped please hit Yes.

Thanks.



"krv" wrote:

How do I highlight different lines within the same cell two different colors?

F2 to enter Edit mode.

Select a portion of the data and click on the Font color picker and select a
color.

Select other portion and color that.

If you wanted a VBA solution I would need to know what de-limiter separates
the string into two lines.


Gord Dibben MS Excel MVP

On Wed, 17 Feb 2010 11:32:01 -0800, krv
wrote:

How do I highlight different lines within the same cell two different colors?