Excel - Alternate Row Color Using Conditional Formatting in Excel

[TeachExcel]

Yes. It doesn't matter if you add or remove rows or columns or cells.

[rrw]

I've always wondered how this is done, good stuff!! Thanks

[supsarah]

Thanks! You helped me so much in my Computer Retail Class! You have a really nice voice, by the way:)

[yink]

Clever I've seen this before but not seen it explained like this.

[bladesNstuff]

If you insert a new row does it automatically correct the color pattern?