MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

Posted by Paul on January 11, 2002 1:53 PM

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.

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.

Posted by Mudface on January 11, 2002 1:57 PM

You could try selecting your area, and choosing a Conditional format formula of


and formatting as blue. (Tip from