Change Background Color in Excel selected Row 1

[shavon]

Hello:

I would like to change the Background color for a selected area in Excel.

For example:

Select Cells A5 to G5 and change the background color to Red.

Any tips please?

Thank you

 

[HughLerwill]

Hot from my Excel Macro recorder;

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 15/01/2007 by Hugh Lerwill

Range("D5:I18").Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End Sub

Condensed;

XlObj.ActiveSheet.Range("D5:I18").Interior.ColorIndex = 6

Hugh,