Prev: CUBEMEMBER
Next: Countif across multiple sheets - sheet NAME issue?
From: krv on 17 Feb 2010 14:32
How do I highlight different lines within the same cell two different colors?

From: trip_to_tokyo on 17 Feb 2010 14:44
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?
>
From: Gord Dibben on 17 Feb 2010 15:00
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 <krv(a)discussions.microsoft.com>
wrote:

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

 | 
Pages: 1
Prev: CUBEMEMBER
Next: Countif across multiple sheets - sheet NAME issue?