Automatic greenbar effect, varied color, corrects with re-format
 

Would like automatic stripe effect in choice of fill color which updates when
columns or rows are deleted as opposed to filling entire worksheets with
color and then having to change to white line-by-line. Also some
spreadsheets have multiple rows for each stripe (in my case each route);
Excel should recognize this in automatically striping to follow the pattern
set.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Automatic greenbar effect, varied color, corrects with re-format
 

Try Chip's article: http://www.cpearson.com/excel/banding.htm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"Brent -- DNA" <Brent -- wrote in message
...
Would like automatic stripe effect in choice of fill color which updates
when
columns or rows are deleted as opposed to filling entire worksheets with
color and then having to change to white line-by-line. Also some
spreadsheets have multiple rows for each stripe (in my case each route);
Excel should recognize this in automatically striping to follow the
pattern
set.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions