How to quickly apply color schemes to spreadsheet rows with OpenOffice
Jun 01, 2010, 21:31 (0 Talkback[s])
How to Help Your Business Become an AI Early Adopter
[ 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
1. Remove any already existing background formatting.
2. Create an appropriate cell style with the color that you want as