Shane A. Stillwell
Zebra Stripes in OpenOffice Calc

Zebra Stripes in OpenOffice Calc

#Apple

Hold on Cowboy

This blog post is pretty old. Be careful with the information you find in here. It's likely dead, dying, or wildly inaccurate.

Open Office is a great alternative to Microsoft Office. It does lack in some areas where as MS Office might provide an easy way to accomplish a task, OpenOffice can usually do it with a little bit of acrobatics.

Zebra Striping in Calc

  1. With Calc opened up, view the Styles and Formatting window (Format > Styles and Formatting)
  2. Right click in the empty white space of that box and select “New”
  3. Name the new cell style “odd”
    1. Change the background color of the cell to a color of your desire
    2. Click OK
  4. Repeat step #2 and create a style called “even”
    1. Change the background color to a different color of your choice
    2. Click OK
  5. Select the range of cells that you want to zebra strip
  6. Click Format > Conditional Formatting…
  7. Change the values in that box to match these
  8. The brains of this operation is the MOD(ROW();2)=0 and MOD(ROW();2)=1
  9. To tweak the formatting just edit the styles “odd” and “even”