coloring cells
 

I want to alternate colors between successive rows. One blue one white, the
next one blue and the next white and so on to the end of my worksheet. It
there a easier way than to hold the control key and click on each row?


Question # 2 when I sort will the colors stay with the row or will they move
with the sort. Is there a way to get the colors to stay even when I sort?

coloring cells
 

You can use conditional formatting which applies the colour using the Mod()
function:

http://www.ozgrid.com/Excel/alternate-row-color.htm

After sorting, every second row remains the same colour as before sorting.


Aaron Blood has a Ledger Shade addin

http://www.xl-logic.com/modules.php?...download&cid=3

You may need to join.

--
Steve

"6371" wrote in message
...
I want to alternate colors between successive rows. One blue one white,
the
next one blue and the next white and so on to the end of my worksheet. It
there a easier way than to hold the control key and click on each row?


Question # 2 when I sort will the colors stay with the row or will they
move
with the sort. Is there a way to get the colors to stay even when I sort?

coloring cells
 

Select a gaggle of rows(not cells) the FormatConditional Formatting

Formula is: =MOD(SUBTOTAL(3,$A1:$A$2),2)=0

Pick your blue color and OK

Alternate row shading will survive sorting and filtering.

Or this version which will not shade blanks rows below your actual data.

=AND(MOD(SUBTOTAL(3,$A1:$A$2),2)=0,COUNTA(ROW())0 )


Gord Dibben MS Excel MVP

On Tue, 21 Apr 2009 16:58:01 -0700, 6371
wrote:

I want to alternate colors between successive rows. One blue one white, the
next one blue and the next white and so on to the end of my worksheet. It
there a easier way than to hold the control key and click on each row?


Question # 2 when I sort will the colors stay with the row or will they move
with the sort. Is there a way to get the colors to stay even when I sort?