VBA Excel - Changing the backcolour of cells

[TomGibbons]

Is this possible? If so, how?

Thanks
Tom

[HELPmyVB]

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

[TomGibbons]

well thats what I need to do.

I am using the following to change the value:

Sheet1.Cells(4, 5).Value =

I want somthing similar to change the back colour

[agmorgan]

This is what I got recording a macro...

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

Surely you can do the same and adapt it??

/Andrew

[HELPmyVB]

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