Set line color in a spread sheet

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a way to count colored cells that are conditionally formatted? 3
Exclude Lines in the calculations on a spread sheet 2
mark unread but in a COLOR? 1
Change cell color in protected sheet 1
Can i search for cells of a particular color 1
Format a spread sheet in minutes and seconds only 2
move cells to other sheet(s) based on color 1
printing a spread sheet 1

Top