Excel tables have a nice little feature that lets you band alternate rows to help visually read the data.
However, to use this, you have to convert the data to a Table. Since this is not always practical, there is an alternative using Conditional Formatting.
The formatting rule is:
This applies the formatting you choose only to those rows that when divided by 2 have no remainder, i.e., even numbered rows. This is especially useful in preventing the shading from go all haywire when the user deletes a row.
But what about conditional formatting on larges swaths of cells that hampers