VBA Excel - Changing the backcolour of cells

Is this possible? If so, how?

Thanks
Tom

it is possible, but how do you intend to specify the required cells that need altering?

well thats what I need to do.

I am using the following to change the value:

VB Code:

Sheet1.Cells(4, 5).Value =

I want somthing similar to change the back colour

This is what I got recording a macro...

VB Code:

Range("E5").Select
    With Selection.Interior
        .ColorIndex = 43
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
    End With

Surely you can do the same and adapt it??

/Andrew

Try this

Range("F7").Select
With Selection.Interior
.ColorIndex = 11 'dark blue. Try other numbers to get what you want
.Pattern = xlSolid
End With

Let me know how you get on