Highlight every other line at one time

[Smreifeis]

I am trying to highlight every other row to make a document easier to read.
As in only high lighting the odd rows. For some reason I just can't seem to
figure this out.

 

[Barb Reinhardt]

You can do this with conditional formatting.

http://www.launchpadzero.net/index.php?name=Tips/excel-alternaterows.html

 

[Dave Peterson]

You may want to look at conditional formatting:
http://www.cpearson.com/excel/banding.htm
(From Chip Pearson's site)

 

[smartin]

I am trying to highlight every other row to make a document easier to read.
As in only high lighting the odd rows. For some reason I just can't seem to
figure this out.

Conditional Formatting. Select your range, set up CF like

Formula is =MOD(ROW(),2)=0

Click Format and apply a light color shading to the cells.