skipping lines

[amazin]

Does anyone know how to highlight every other line
easily - a master stroke instead of control + click on
lines? Sometimes I want to color alternate lines.

 

[Jason Morin]

You could do this:

1. Press Ctrl+A.
2. Format > Conditional Formatting
3. Select "Formula Is" and insert:
=MOD(ROW(),2)=0
4. Press the "Format" button, select Pattern tab, and
choose a color.

HTH
Jason
Atlanta, GA

 

[jeff]

Hi
see
http://www.cpearson.com/excel/banding.htm
jeff

 

[mzehr]

Hi,
You could also try this for Coloring Alternating Rows
by Don Guillett

Sub colorrow()
For i = 1 To 300 Step 2
Rows(i).Interior.ColorIndex = 15
Next i


See also Chip Pearson's site for other options:
http://www.cpearson.com/excel/banding.htm

HTH

 

[RagDyer]

And let's not forget XL's contribution to this.
<Format> <AutoFormat>
And scroll down to "List 1" or "List 2" or whatever else might strike your
fancy.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Does anyone know how to highlight every other line
easily - a master stroke instead of control + click on
lines? Sometimes I want to color alternate lines.