Format text in a cell into lines and conditional coloring

[Namster1]

Hi

I wonder if you can help me. I have 2 problems which I need to solve asap and I am willing to beg for help!

I am trying to create a follow-up spreadsheet with an actions column. But my boss wants the column to have text numbered in rows in the cell. So e.g Actions for an item might be:
1-send letter
2-call office
3-make coffee (upto 5 max)

this list will need to be typed in, and I have tried to make excel launch a box in which the user types in the text. But that didnt work. I know how to wrap the cell but I cant get each action on a new line easily? any ideas?

Problem 2 more interesting. I have a priorities field. In which A B, C, D and E are entered (in an other language) Cells B9:B109. And I want to get conditional formating to color the boxes appropriatly. But I cant use the other language characters. So I created a formula in an other column N9:N109 which checks the Char in B column and places a number in the equivilant row in N column. But the macro to set icolor wont run on the formula! so I am now screwed!

Here is macro

Private Sub Worksheet_Change(ByVal Target As Range)
Dim icolor As Integer

    If Not Intersect(Target, Range("N9:N109")) Is Nothing Then
        Select Case Target
            Case Is = ""
                icolor = 2
            Case Is = 1
                icolor = 3
            Case Is = 2
                icolor = 44
            Case Is = 3
                icolor = 36
            Case Is = 4
                icolor = 8
            Case Is = 5
                icolor = 35
        Case Else
                icolor = 1

                'Whatever
        End Select
        Target.Offset(0, -12).Interior.ColorIndex = icolor
    End If

End Sub

I am sure this would be really easy for gurus but I am not too bright and I dont know why my boss wants it in excel.. when we can do it in Access. Still, I would appreciate any help on these problems.... thank you..

N

 

[RalphA]

For your list in one cell, format the cell using Format, Cells, Alignment, Wrap Text, OK.
Enter the first line:
1-send letter
Hold down Alt and press Enter.

Enter the second line:
2-call office
Hold down Alt and press Enter.

And so on.

 

[Namster1]

Thank you that works

Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you

Its so simple when you know how!!... and its exactly what I needed... Thank you

I owe you one...

N

 

[RalphA]

We are happy when we manage to help someone, such as yourself.

Actually, some one else posted this answer some time ago. I remembered that it could be done, and, after experimenting a bit, I was lucky enough to hit on the method once again.