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?

This should do it for ya:
http://www.ozgrid.com/Excel/alternate-row-color.htm


Regards,
Ryan--

--
RyGuy


"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?

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?