Alternating every other row different colors

[MICHELLE1]

I have a very large spreadsheet created in Excel. I am trying to alternate
every other row grren and then Pink. However, I can't seem to figure out how
to do it other then doing it by each individual row. Is there a way to do
this by highlighting what I need to alternate and plugging in the colors and
it do it for me so I do not have to do it individually? If you could help me
with this it would be greatly appreciated. Thank you...!

 

[JE McGimpsey]

See

http://cpearson.com/excel/banding.htm

 

[Sebation.G]

u can use the codtional formatting.
1 set the worksheet backgroud color :green
2 use the conditional formatting
formula:"=mod(row(),2)=0"
the backgroud color set pink

 

[Joel]

You can use conditional formating or use a VBA macro. Lots of people will
respond with conditional formating. here is VBA code

Sub Color_Pink_GREEN()
'

'
Const EndColumn As String = "F"
Const EndRow As Integer = 94
Const StartColumn As String = "A"
Const StartRow As Integer = 3

Const SHADEPINK As Integer = 7
Const SHADEGREEN As Integer = 10

Dim RowOffsetCount As Integer

For RowCount = StartRow To EndRow

Range(StartColumn + CStr(RowCount) + ":" + _
EndColumn + CStr(RowCount)).Select

With Selection.Interior
Select Case (RowCount Mod 2)

Case 0
.ColorIndex = SHADEPINK
.Pattern = xlSolid
Case 1
.ColorIndex = SHADEGREEN
.Pattern = xlSolid
End Select

End With


Next RowCount

End Sub

 

[MICHELLE1]

Thank you, thank you, thank you!! It worked!!!!!!!

u can use the codtional formatting.
1 set the worksheet backgroud color :green
2 use the conditional formatting
formula:"=mod(row(),2)=0"
the backgroud color set pink

I have a very large spreadsheet created in Excel. I am trying to alternate
every other row grren and then Pink. However, I can't seem to figure out

[quoted text clipped - 5 lines]

me
with this it would be greatly appreciated. Thank you...!