highlighting different line in a cell
How do I highlight different lines within the same cell two different colors?
|
highlighting different line in a cell
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? |
highlighting different line in a cell
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? |
All times are GMT +1. The time now is 08:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com