Yes to locking the banding scheme.

Use Conditional Formatting.

Select the rows to band.

FormatConditional FormattingFormula is:

=MOD(ROW(),2)=1

Pick a color from Format and OK your way out.

NOTE: you do have to band entire rows.

Select A1:H100 and follow steps above.


Gord Dibben MS Excel MVP

On 27 Jul 2006 11:45:43 -0700, wrote:

I have a question regarding saving fomatting while deleting cells.
Essentially I have a large amount of data where rows are constantly
being added and deleted. My rows are grey-white-grey-white,etc and
want to keep them that way, but everytime I delete or add a row, it
messes up my color-scheme. Is there a way to lock the color of rows?
Is there a way around this that will accomplish my goal?