Highlight every other line at one time
 

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.

Highlight every other line at one time
 

You can do this with conditional formatting.

http://www.launchpadzero.net/index.p...rnaterows.html
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Smreifeis" wrote:

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.

Highlight every other line at one time
 

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

Smreifeis wrote:

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.

--

Dave Peterson

Highlight every other line at one time
 

Smreifeis wrote:
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.