highlighting different line in a cell

[krv]

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

 

[trip_to_tokyo]

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.

 

[Gord Dibben]

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