Open Office Calc (Spreadsheet) Adding Background colour to every second line
(This blog was written for versions of OpenOffice up to Version 3.4.0)
If working on a spread sheet there can be advantages to have each second row shaded in a particular colour throughout the sheet. This will stay constant even if rows are deleted or added to the sheet during work on it.
Open an ‘Open Office Calc’ document
Select any single cell within the sheet to format it with the colour required.
Go to Format > Cells > Background > click on colour required > click on OK
Next step is to give that format a name. Go to Format > Styles and Formatting > In the Styles and Formatting Window > click on the ‘New style from Selection’ Icon (the middle icon at the top right hand corner of the Window). Hover the cursor over the icon and the name will appear to confirm it is the right icon.
In the ‘Create Style’ Window > Style name > insert a name of the colour to identify the background chosen > click OK. This inserts that name in the list on the Style and Formatting Window. Close the Style and Formatting Window by clicking on the ‘X’ in the top right hand corner.
Go back to the Spreadsheet and take the format off the chosen cell. (Format > Cells > Background > choose No Fill > click OK)
Select all cells in the spread sheet either ‘Ctrl + A’ or Click the blank cell in the top left hand corner of the spread sheet at the intersection of the row and line number.
Now apply conditional formatting to the entire sheet. Go to Format > Conditional Formatting. In the Conditional Formatting Window > tick the Condition 1 box > in the spin box below that change to ‘Formula is’ In the box opposite this type in formula “mod(row()+1;2)=1” without the inverted commas. In the Cell Style from the drop down choose the colour there that was chosen previously for the spreadsheet. Click OK.
Take the highlighting off the spread sheet by clicking somewhere within the spreadsheet and every second row will be the chosen colour.
If intending to use this regularly on new spreadsheets save as a Template.