Ask Your Question

[calc] alternating color for row pairs

asked 2019-08-27 10:52:05 +0100

questionaire gravatar image

Hi everyone,

I'd like to add alternating colors to my spreadsheets. However, not every single row, but every pair of rows. e.g. rows 1+2 grey, 3+4 white, 5+6 grey, ...

Thanks in advance!

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-08-27 12:35:53 +0100

m.a.riosv gravatar image

Using conditional format (Menu/Format/Conditional) with a formula like:

image description

seems can do the job.

edit flag offensive delete link more


this did it, thank you!

questionaire gravatar imagequestionaire ( 2019-08-27 13:36:44 +0100 )edit

answered 2019-08-27 11:26:58 +0100

ebot gravatar image
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-27 10:52:05 +0100

Seen: 59 times

Last updated: Aug 27