TheJoe.it Into the (open) source

4Mar/1213

LibreOffice “Calc”: coloring alternate rows

calc_logo

When we have a small table (one or two pages maximum) give a color to the background of the rows alternately can be a procedure, although manual, fast enough. But what happens when we have a table to more 1.000 record? The method of copy paste quote manual may also be an acceptable solution, but unnecessarily lose a lot of time, then I started to look for a method that I did save some money and I found the Conditional Formatting.

The Conditional Formatting is nothing more than the imposition of the conditions to the spreadsheet. If the condition is satisfied there will be a consequence, if it is not satisfied with the result will be another.