Use Conditional Formatting to color the alternate rows.

The banding will remain through row deletions, sorting and filtering.

Select a couple hundred rows then.....

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

Pick one color from FormatPatterns and OK your way out.


Gord Dibben MS Excel MVP

On Wed, 9 Jan 2008 13:46:01 -0800, confused
wrote:

I've setup a spread sheet with everyother line colored to highlight the
information. However if I go to change the data in search of something the
line color follows the information. I've tried making a template and setting
the line color but that doesnt work for me either. Is there a way to setup a
sheet with everyother line colored either as a template or a water mark so
it's permanent and does not follow the information around?