Zebra striping in Libreoffice/Openoffice

  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 Formating…
  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 formating just edit the styles “odd” and “even”

Ref: http://www.shanestillwell.com/blog/2008/06/27/zebra-stripes-openoffice-calc


Enter your comment. Wiki syntax is allowed:
If you can't read the letters on the image, download this .wav file to get them read to you.