2013-01-03

OpenOffice alternate background color on rows

Thought I'd write down a short post on how to do this thing, I've been wondering for a long time and finally took the time to figure out how to actually do it.

The easiest way I found was to goto Format/Conditional Formatting change to "Formula is" and then write ISEVEN(ROW()) and then change the style to something interesting.

The end result? I made it so each even row got a light cyan blue, and the spread sheet was waaaaaay easier to read :)

Inga kommentarer:

Skicka en kommentar