Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Alternating row colors remaining after insert
Posted by Ray Ragusa on January 11, 2002 1:48 PM
I have a spreadsheet with alternating rows of color, (blue, white, blue, white, etc.). When I insert new rows, I want the spreadsheet to automatically make up for the new row or rows and adjust the sheet to follow the existing color pattern (without changing data). How? Thanks in advance.
Re: Alternating row colors remaining after insert
Posted by Paul on January 11, 2002 1:53 PM
=MOD(ROW(),2)=0
Select the range you want to format. Format > Conditional Formatting. In the left dropdown,
change ""Cell Value is"" to ""Formula Is"". In the formula box type. Click the
""Format..."" button. Click the Patterns tab and pick a color " if you want every other row a different color click add and put =MOD(ROW(),1)=0 in that box.
Re: Alternating row colors remaining after insert
Posted by Denise Hoosier on January 11, 2002 1:55 PM
I would click on the row underneath the new one, through the ending row of the spreadsheet, click on Format Painter, then click on the new row.
Re: Alternating row colors remaining after insert
Posted by Mudface on January 11, 2002 1:57 PM
You could try selecting your area, and choosing a Conditional format formula of
=Mod(Row(),2)=0
and formatting as blue. (Tip from http://www.j-walk.com/ss/excel/usertips/tip043.htm)
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.