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

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

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