Alternating row backgrounds / conditional formatting in OpenOffice.org
Posted: 26 May 2011 Filed under: open source, productivity | Tags: openoffice.org 8 CommentsHave you put together an OpenOffice.org table in OpenOffice.org Calc, and wanted to display alternating backgrounds for easy reading? Well, there’s an easy way to do it.
The steps are:
- Create a style for every other row and call it “Even rows.” Make its background “Gray 10%,” or whatever other color and attributes you prefer.
- In your spreadsheet, select the range of rows you’d like to format.
- In the Format menu, click “Conditional Formatting…”.
- Choose “Formula is” in the first dropdown.
- For the condition itself, enter the formula
ISEVEN(ROW())
. This formula tests if the current row in question is even or not. If it is, the condition is met and your style is applied. - For Cell Style, select the style you created back in Step 1.
- Click OK. There you go.