Select the number of rows to color...say 100.....then FormatConditional
FomattingFormula is

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Format to a nice color.

This will retain the row formatting throughout sorting or filtering.


Gord Dibben MS Excel MVP

On Tue, 27 Nov 2007 12:40:00 -0800, deann
wrote:

How do I fill every other line with color in an excel spreadsheet without
doing it line by line?