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?