v2003 more than 3 conditions- colors

**IsabellaLearning** · 11-11-2010, 10:06 PM

hello all,

I am wanting all cells in range:G18-AC53 with the number 1 to be red,with number 2 to be pink, number 3 to be green, number 4 to be yellow and number 5 to be black. Only in one sheet called test of a workbook with 5 sheets. Is this possible?

Is

**Trebor76** · 11-11-2010, 11:55 PM

Hi there,

Try this Worksheet_Change event macro*

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Range("G18:AC53")) Is Nothing Then
        With Target
            Select Case .Value
                Case 1
                    .Interior.Color = RGB(255, 0, 0) 'Red
                Case 2
                    .Interior.Color = RGB(255, 0, 255) 'Pink
                Case 3
                    .Interior.Color = RGB(0, 255, 0) 'Green
                Case 4
                    .Interior.Color = RGB(255, 255, 0) 'Yellow
                Case 5
                    .Interior.Color = RGB(0, 0, 0) 'Black
            End Select
        End With
    End If

End Sub

* To install and subsequently modify this macro, follow these four steps:

1. Copy my code to the clipboard Ctrl + C
2. Right-click on the tab you wish the code to run on and from the shortcut menu select View Code
3. Paste Ctrl + V my code from step 1 into the blank module
4. From the File menu click Close and Return to Microsoft Excel

Regards,

Robert

**IsabellaLearning** · 11-14-2010, 02:48 AM

thank you!!!
exactly what i wanted

I really appreciate it

Is

**Paul** · 11-14-2010, 02:55 AM

Isabella, in the future please do not cross-post without providing a link to the other post(s). In this instance, two people worked on a solution for you, and one ended up wasting time as a solution was provided elsewhere.

Future cross-posts without links will be closed.

http://www.mrexcel.com/forum/showthread.php?t=508424

Please review the forum rules, for which there is a link in my signature below.

**IsabellaLearning** · 11-14-2010, 03:07 AM

Hi Paul,

Yes it was my mistake, i was posting from my parents house and had both urls open, couldnt find the post, thought it hadnt worked and resent it - then realised a few hours later it was on 2 different urls...

apologies
Is