Alternating every other row different colors
 

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

Alternating every other row different colors
 

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

Alternating every other row different colors
 

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

Alternating every other row different colors
 

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

Alternating every other row different colors
 

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