Set line color in a spread sheet

  • Thread starter Thread starter confused
  • Start date Start date
C

confused

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.....

Format>Conditional Formatting>Formula is: =MOD(SUBTOTAL(3,$A1:$A$2),2)=0

Pick one color from Format>Patterns and OK your way out.


Gord Dibben MS Excel MVP
 
Back
Top