I often like to highlight even or odd rows in a spreadsheet in order to make it easier to read. This can become labor intensive when you have a lot of data. Today, I am going to show you how to do it quickly in LibreOffice’s Calc program.
First, you need to highlight all the data within the highlight range, this includes the even and odd rows.
In the menus, Format > Conditional Formatting. In the Conditional Formatting dialog, click the New Style button. On the Organizer tab, give the style a name like “Row Highlight”.
Move to the Background tab and select your highlight color.
Click OK. The style in the Cell Style drop down will change to the style you just created. Change the condition of the style to Formula is and type ISEVEN(ROW()) into the input box. Click OK.
Now, your even numbered rows are highlighted.
You can do the same thing with odd rows by using ISODD(ROW()). To get the same effects on columns, you can use ISEVEN(COLUMN()) and ISODD(COLUMN()).
For more on LibreOffice, check out my articles in Full Circle magazine.
