highlighting different line in a cell

  • Thread starter Thread starter krv
  • Start date Start date
K

krv

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlight active cell with font color? 3
Excel Highlighting duplicates 0
row and cell highlighted 2
Conditional format a column based on value in a different column 3
Highlight Highest Amount 2
Conditional Formatting Based on Cell Content 3
Excel Typed text appears in wrong cell 0
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1

Back
Top