Background color in every other line in open office or exel?

Question

I'm new to both programs, and would prefer Open office's explanation because that it what i am using. But i current have a 30 page project that doesn't have every other line highlighted with a light grey, but now would like it. Is there a easier way to highlight them rather that going manually line by line?

Answer 1

use your color icon form toolbar by one click for every cell.

Answer 2

You could write a macro to do this.

Go down the colums and if the cell row is odd, color the background one color, if it is even color the background the other color. I'm sorry that I don’t have time at the moment to write this myself.

Note that even without that, you can change the background color in an entire row in one step. Just left-click on the row number, and the entire row will be selected. Then select Format → Cells → Background and pick the color you want. Indeed you can pick all row 1 and all the odd-numbered rows in a sheet before you make your color selection, and color them all at once.

Answer 3

openoffice took me a little while(i will tell you why below)

make a format with grey highlighting

steps(just in case)

- click format

- click styles&formatting

- click new style from selection icon

- give it a name (greyhilit)

- rightclick on greyhilit and choose the background color

just click around a few cells apply the style to and make sure it works.

then go to conditional formatting

- highlight all 550 cells

- click format

- click conditional formatting

- click cell value is, and change it to formula is

- copy&paste this formula

=MOD(ROW();2)

- click cell style to greyhilit

-now you should be able to insert rows, and the highlighting will auto-adjust

enjoy (hope i wasnt too late)

in excel you would use the formula

=MOD(ROW(),2)=0

the comma makes a difference (i am going to have to remember that), because it wasnt working for me in OoCalc