Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to alternately variegate rows
How can I alternately variegate rows. I want to make every other row white
and every other row off white so the rows can be easily differentiated? Also, since my document already has over 450 rows, is there a simple way to alternately veriegate these rows? This is a great group. I have been helped many times here. I thank you in advance for any help you might give me with this issue. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to alternately variegate rows
Pick one of the methods listed here.
http://www.google.com/search?hl=en&q...+rows&aq=f&oq= lawrencae wrote: How can I alternately variegate rows. I want to make every other row white and every other row off white so the rows can be easily differentiated? Also, since my document already has over 450 rows, is there a simple way to alternately veriegate these rows? This is a great group. I have been helped many times here. I thank you in advance for any help you might give me with this issue. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to alternately variegate rows
You can use Conditional Formatting.
Select 500 rows then............ FormatCFFormula is =MOD(ROW(),2)=1 Note: this will not survive Filtering =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Will survive filtering Pick the one color only. Default will be no color(white) Gord Dibben MS Excel MVP On Wed, 27 Aug 2008 06:34:01 -0700, lawrencae wrote: How can I alternately variegate rows. I want to make every other row white and every other row off white so the rows can be easily differentiated? Also, since my document already has over 450 rows, is there a simple way to alternately veriegate these rows? This is a great group. I have been helped many times here. I thank you in advance for any help you might give me with this issue. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions |