Ask Your Question

ISEVEN changes alternate row formatting [closed]

asked 2012-12-31 15:39:01 +0200

snison gravatar image


When I use this ( and other methods found, specifically using ISEVEN(ROW()), it takes away the "center" formatting of the last column (F). When I try to correct this, it only changes the formatting for the even columns.

If I try to justify column C it also only does it for every even column.

How can I color alternate rows but keep formatting per column?


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 01:06:33.847279


I'm afraid this doesn't answer the question, if it refers to mariosv's reply. What exactly does that mean, "set up one style for every different column format"? Even after defining and applying a new style to an entire column, applying the ISEVEN(ROW()) conditional formatting overrides any pre- or post-defined styles.

gtomorrow gravatar imagegtomorrow ( 2016-02-06 08:04:43 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-01-15 21:58:34 +0200

m.a.riosv gravatar image

You need to set up one style for every different column format.

edit flag offensive delete link more

answered 2013-01-15 06:53:10 +0200

snison gravatar image

Bump bump bump

edit flag offensive delete link more

Question Tools



Asked: 2012-12-31 15:39:01 +0200

Seen: 993 times

Last updated: Jan 15 '13