Bernhard Brunner's Blog

Link to this comparison view

--- blog:zebra_striping_in_libreoffice:openoffice [2011-03-08 17:07] – created brb
+++ blog:zebra_striping_in_libreoffice:openoffice [2011-03-08 17:12] (current) – brb
@@ Line 4: / Line 4: @@
   - Right click in the empty white space of that box and select "New"
   - Name the new cell style "odd"
-. Change the background color of the cell to a color of your desire
+    - Change the background color of the cell to a color of your desire
-. Click OK
+    - Click OK
   - Repeat step #2 and create a style called "even"
-. Change the background color to a different color of your choice
+    - Change the background color to a different color of your choice
-. Click OK
+    - Click OK
    - Select the range of cells that you want to zebra strip
    - Click Format > Conditional Formating...
    - Change the values in that box to match these
+   - The brains of this operation is the MOD(ROW();2)=0 and MOD(ROW();2)=1
+   - To tweak the formating just edit the styles "odd" and "even"
-{{tag>}}
+{{:blog:zebra_striping_in_libreoffice:conditional_formating.png?500|}}
+Ref: http://www.shanestillwell.com/blog/2008/06/27/zebra-stripes-openoffice-calc
+{{tag>openoffice libreoffice spreadsheet}}
 ~~LINKBACK~~
 ~~DISCUSSION~~