[ Thanks to M.
Fioretti for this link. ]
“How do you quickly create a spreadsheet where, for
example, every other line has a background of a different color?
Here are a couple of methods.“The first one is faster (and works even in controlled
environments where you can’t install extensions) if you want white
rows alternated with colored ones: define a cell style and apply it
only to cells in even (or odd) rows. Here is the detailed
procedure:1. Remove any already existing background formatting.
2. Create an appropriate cell style with the color that you want as
background:”