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...!

See

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


In article <72a85bb595048@uwe, "MICHELLE1" <u34488@uwe wrote:

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...!

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

--
Regards,

Sebation.G

"MICHELLE1" <u34488@uwe дÈëÏûÏ¢ÐÂÎÅ:72a85bb595048@uwe...
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...!

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

Sebation.G wrote:
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...!

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" wrote:

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...!