Howdy, it has been a little while since my last post.
I had to produce a landscape spreadsheet in OpenOffice the other day and for ease of reading when it was printed I needed alternating row backgrounds. My initial thought was there must be a magic button for this, no such luck. Luckily the solution is quite simple though and it can be adapted to alternate column backgrounds too.
Highlight the cells you want to have alternating row colours and then:
- Format
- Conditional Formatting
- Tick Formula 1
- Choose “Formula is” in first drop down
- Second drop down should be “Equal to”
- In the empty text box enter: ISODD(ROW()) or ISODD(COLUMN())
- Then select the type of formatting you want.