[Solved] Background Color Alternating Row Fill

[pjoseph]

How does one fill a background color in every other row in a sheet?

For example: I want all odd numbered rows with white background, and all even numbered rows with a light green background.

Menu: Format->Styles and Formatting
Result style, right-click and modify; Background tab, and chose light green color.
Selected the range of cells;
Menu: Format->Conditional Formatting
Checked Condition 1, changed Cell value is to Formula is,
Entered formula ISEVEN(ROW()), and changed Cell Style to Result.

Thanks.

[Villeroy]

Apply one cell-style to the cells and creat a second style for the alternate rows.
Select the range in question
menu:Format>Conditional...
[X] Condition 1
change "Value Is" to "Formula Is" and use one of the following expressions with the style you defined for alternate columns.
ISEVEN(ROW())
ISODD(ROW())
NOT(MOD(ROW();2))
MOD(ROW();2)
the latter 2 work with every 3rd, 4rth, ... as well.

[ken johnson]

The SUBTOTAL function enables alternate row shading of filtered columns.
The attachment compares shading based on visibility with that based on row number...

Alt Shade of Visible Rows.ods

Notice columns A and B maintain alternate shading when filtered.

(15.01 KiB) Downloaded 8323 times

Ken Johnson

[Ben2K]

Bravo!!! Great tip!

[ayani0sby]

In Microsoft Excel:

Code: Select all

=MOD(ROW(),2)=0

OpenOffice :

Code: Select all

MOD(ROW();2)=0

Please try it,

[cstanford]

Using these formulas I find that OO will only shade rows and cells that have no contents in them. If a row has a cell entry, it will not shade that row or cell. Can anybody help with this?