Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Shading alternating rows
4 views
Skip to first unread message
Lisa
Apr 15, 2003, 11:29:33 AM4/15/03
to
Is there a way to shade every other row? I have a
spreadsheet that is 25 pages, portrait format, 10 columns
and lots of numbers. In order to follow the information
more easily I would like to shade every other row and
can't figure out how to do it other than doing a fill and
then copying the format over and over again.
spreadsheet that is 25 pages, portrait format, 10 columns
and lots of numbers. In order to follow the information
more easily I would like to shade every other row and
can't figure out how to do it other than doing a fill and
then copying the format over and over again.
Ron de Bruin
Apr 15, 2003, 11:36:47 AM4/15/03
to
Check out
http://cpearson.com/excel/banding.htm
http://cpearson.com/excel/banding.htm
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl
"Lisa" <lisa.d...@prudential.com> wrote in message news:06b701c30363$d0ea7da0$a501...@phx.gbl...
Don Guillett
Apr 15, 2003, 11:37:31 AM4/15/03
to
Lisa,
A good time to learn to use the archives or get Ron's google add in.
http://www.rondebruin.nl/Google.htm
A good time to learn to use the archives or get Ron's google add in.
http://www.rondebruin.nl/Google.htm
--
Don Guillett
SalesAid Software
Granite Shoals, TX
don...@281.com
"Lisa" <lisa.d...@prudential.com> wrote in message
news:06b701c30363$d0ea7da0$a501...@phx.gbl...
Wilson
Apr 15, 2003, 11:42:53 AM4/15/03
to
One way, Lisa:
Sub Greenbar()
Dim r As Integer
Dim LstRow As Integer
LstRow = Cells(rows.Count, "A").End(xlUp).Row
For r = 2 To LstRow Step 2
Cells(r, 1).EntireRow.Interior.ColorIndex = 4
Next r
End Sub
Choose the shading you wish ColorIndex = 15, perhaps
HTH
Sub Greenbar()
Dim r As Integer
Dim LstRow As Integer
LstRow = Cells(rows.Count, "A").End(xlUp).Row
For r = 2 To LstRow Step 2
Cells(r, 1).EntireRow.Interior.ColorIndex = 4
Next r
End Sub
Choose the shading you wish ColorIndex = 15, perhaps
HTH
Max
Apr 15, 2003, 11:56:00 AM4/15/03
to
Press Ctrl+A to select entire worksheet
(or select the desired area)
(or select the desired area)
Click Format>Conditional Formatting
Select "Formula Is" from the drop menu
Enter: =mod(row(),2) in the box just beside
Click the Format button
Select Patterns tab
Click on a light pastel colour (light green, say)
Click OK
Click OK again at the Conditional Formatting dialog
hth
Max
>.
>
Lisa
Apr 15, 2003, 1:21:06 PM4/15/03
to
Thanks everyone for your quick responses, you all helped
me with my problem!>.
>
me with my problem!
>
norm601
Apr 15, 2003, 12:24:43 PM4/15/03
to
The easy way is to use AutoFormat. It will give you several possible
choices.
choices.
0 new messages