look of excel

[NoS...@willwork.com]

How do I change the layout so that alternating rows are different
colors, such as maybe gray and white.
Makes it easier on the eye to follow along when rows aren't close
together.

[BUnglesbee]

You can use the Format, Cells, Patterns tab. Be sure you select your desired
rows first. Choosing a light color shading will make your text more easily
read.

HTH
Beth
Microsoft MVP - Excel

[Bill Manville]

On Wed, 26 Nov 1997 16:21:30 GMT, NoS...@willwork.com wrote:

>How do I change the layout so that alternating rows are different
>colors, such as maybe gray and white.
>Makes it easier on the eye to follow along when rows aren't close
>together.

Sub ShadeAlternateLines()
Dim iRow As Integer
For iRow = 2 To Range("A1").SpecialCells(xlLastCell).Row Step 2
Rows(iRow - 1).Interior.ColorIndex = xlNone
Rows(iRow).Interior.ColorIndex = 15
Next iRow
End Sub

Bill Manville
Oxford, England
Microsoft Excel - MVP

[Robert Rosenberg]

You can also check out the Format-->AutoFormat command. I believe they
have two formats (List 2 & 3D Effects 2) that will do what you want. If
you are only looking for the alternating row effect, then make sure you
Click the options button & turn OFF everything but the "Border" &
"Patterns" options.

At the very least, this technique will give you a running start at your
desired look. You can, of course, format the results further.

Sincerely,
---
Robert Rosenberg
Microsoft MVP - Excel
----------------