An example
'-----------------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
'-----------------------------------------------------------------
Const WS_RANGE As String = "H1:H10" '<=== change to suit
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
Select Case .Value
Case 1: .Interior.ColorIndex = 3 'red
Case 2: .Interior.ColorIndex = 6 'yellow
Case 3: .Interior.ColorIndex = 5 'blue
Case 4: .Interior.ColorIndex = 10 'green
End Select
End With
End If
ws_exit:
Application.EnableEvents = True
End Sub
'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

Signature
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
> Hi,
>
[quoted text clipped - 5 lines]
>
> Dave
Risky Dave - 25 Sep 2007 13:02 GMT
Bob,
Many thanks for your prompt response.
Guess that means I'll have to do some work now :-)
Dave
> An example
>
[quoted text clipped - 34 lines]
> >
> > Dave
Bob Phillips - 25 Sep 2007 14:28 GMT
You could try this http://www.xldynamic.com/source/xld.CFPlus.Download.html

Signature
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
> Bob,
>
[quoted text clipped - 44 lines]
>> >
>> > Dave
Risky Dave - 25 Sep 2007 15:46 GMT
Outstanding. My thanks
> You could try this http://www.xldynamic.com/source/xld.CFPlus.Download.html
>
[quoted text clipped - 46 lines]
> >> >
> >> > Dave