software

I usually create a color pattern alternating between a white and gray
background for the rows in my Excel worksheets to improve overview in sheets
with a lot of columns. The problem with that is that I have to keep redoing
the pattern every time I add or delete rows.
Adding an option in Excel to natively show rows or columns with this pattern
that would adjust automatically when rows are added or deleted would be a
great feature that would greatly improve overview of the data when working
with large worksheets. The colors should be customizable and there should be
an option to choose whether to print the pattern or not.----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc

In the meantime, you can use conditional formatting to highlight rows.
Conditional formatting is available in XL2000 and later

Select all the rows you want affected by the shading
On the menus choose Format-gt;Conditional Formatting
Chose Formula is and type

=mod(row(),2)=0 (this is for alternating rows - change the 2 to a 3 for
every third row, etc)

Click on the format button amp; choose a color on the Patterns tab.
OK your way back to the spreadsheet

Now inserting and deleting rows will not change the highlighting.
quot;Fedaquot; wrote:

gt; I usually create a color pattern alternating between a white and gray
gt; background for the rows in my Excel worksheets to improve overview in sheets
gt; with a lot of columns. The problem with that is that I have to keep redoing
gt; the pattern every time I add or delete rows.
gt; Adding an option in Excel to natively show rows or columns with this pattern
gt; that would adjust automatically when rows are added or deleted would be a
gt; great feature that would greatly improve overview of the data when working
gt; with large worksheets. The colors should be customizable and there should be
gt; an option to choose whether to print the pattern or not.
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc

Forgot to mention that I've created a small add-in - Greenbar.xla - to assist
in shading rows. My wife works in a department in which they frequently
examine text files coming from a mainframe app. 70 or 80 columns amp; thousands
of rows. She amp; her co-workers needed the greenbar shading to assist the
reviews and asked me for help.

If you'd like I can email it to youquot;Fedaquot; wrote:

gt; I usually create a color pattern alternating between a white and gray
gt; background for the rows in my Excel worksheets to improve overview in sheets
gt; with a lot of columns. The problem with that is that I have to keep redoing
gt; the pattern every time I add or delete rows.
gt; Adding an option in Excel to natively show rows or columns with this pattern
gt; that would adjust automatically when rows are added or deleted would be a
gt; great feature that would greatly improve overview of the data when working
gt; with large worksheets. The colors should be customizable and there should be
gt; an option to choose whether to print the pattern or not.
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc

That worked like a charm. Thank you!
I still hope they add this feature in the future so it can be set as a
default setting for all the worksheets.

quot;Duke Careyquot; wrote:

gt; In the meantime, you can use conditional formatting to highlight rows.
gt; Conditional formatting is available in XL2000 and later
gt;
gt; Select all the rows you want affected by the shading
gt; On the menus choose Format-gt;Conditional Formatting
gt; Chose Formula is and type
gt;
gt; =mod(row(),2)=0 (this is for alternating rows - change the 2 to a 3 for
gt; every third row, etc)
gt;
gt; Click on the format button amp; choose a color on the Patterns tab.
gt; OK your way back to the spreadsheet
gt;
gt; Now inserting and deleting rows will not change the highlighting.
gt;
gt;
gt;
gt; quot;Fedaquot; wrote:
gt;
gt; gt; I usually create a color pattern alternating between a white and gray
gt; gt; background for the rows in my Excel worksheets to improve overview in sheets
gt; gt; with a lot of columns. The problem with that is that I have to keep redoing
gt; gt; the pattern every time I add or delete rows.
gt; gt; Adding an option in Excel to natively show rows or columns with this pattern
gt; gt; that would adjust automatically when rows are added or deleted would be a
gt; gt; great feature that would greatly improve overview of the data when working
gt; gt; with large worksheets. The colors should be customizable and there should be
gt; gt; an option to choose whether to print the pattern or not.
gt; gt;
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt; www.microsoft.com/office/comm...lic.excel.misc

I want to do something related, which is this:
I want to select the entire worksheet and say things like quot;If column E says
quot;xquot; then color the associated rows blue;quot; quot;If column A has quot;*quot; or **quot; then
apply StyleY to the rows.quot; I want to make a whole bunch of statements like
this, and then save it as a flexible template- where the formatting is
referenced to cell text and formatting- not set column/row numbers. I can't
figure out how to do it based on the user-friendly quot;prompt featuresquot;...but it
sounds like if I learn how to write the statements then I can make this
happen? Any insight would be very much appreciated.

quot;Duke Careyquot; wrote:

gt; Forgot to mention that I've created a small add-in - Greenbar.xla - to assist
gt; in shading rows. My wife works in a department in which they frequently
gt; examine text files coming from a mainframe app. 70 or 80 columns amp; thousands
gt; of rows. She amp; her co-workers needed the greenbar shading to assist the
gt; reviews and asked me for help.
gt;
gt; If you'd like I can email it to you
gt;
gt;
gt; quot;Fedaquot; wrote:
gt;
gt; gt; I usually create a color pattern alternating between a white and gray
gt; gt; background for the rows in my Excel worksheets to improve overview in sheets
gt; gt; with a lot of columns. The problem with that is that I have to keep redoing
gt; gt; the pattern every time I add or delete rows.
gt; gt; Adding an option in Excel to natively show rows or columns with this pattern
gt; gt; that would adjust automatically when rows are added or deleted would be a
gt; gt; great feature that would greatly improve overview of the data when working
gt; gt; with large worksheets. The colors should be customizable and there should be
gt; gt; an option to choose whether to print the pattern or not.
gt; gt;
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt; www.microsoft.com/office/comm...lic.excel.misc

Your green bar add in sounds great could you send it to me as well? Thanks.
quot;Duke Careyquot; wrote:

gt; Forgot to mention that I've created a small add-in - Greenbar.xla - to assist
gt; in shading rows. My wife works in a department in which they frequently
gt; examine text files coming from a mainframe app. 70 or 80 columns amp; thousands
gt; of rows. She amp; her co-workers needed the greenbar shading to assist the
gt; reviews and asked me for help.
gt;
gt; If you'd like I can email it to you
gt;
gt;
gt; quot;Fedaquot; wrote:
gt;
gt; gt; I usually create a color pattern alternating between a white and gray
gt; gt; background for the rows in my Excel worksheets to improve overview in sheets
gt; gt; with a lot of columns. The problem with that is that I have to keep redoing
gt; gt; the pattern every time I add or delete rows.
gt; gt; Adding an option in Excel to natively show rows or columns with this pattern
gt; gt; that would adjust automatically when rows are added or deleted would be a
gt; gt; great feature that would greatly improve overview of the data when working
gt; gt; with large worksheets. The colors should be customizable and there should be
gt; gt; an option to choose whether to print the pattern or not.
gt; gt;
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt; www.microsoft.com/office/comm...lic.excel.misc