Ask Your Question

Colour alternate rows without disturbing existing format

asked 2017-08-13 08:29:08 +0200

nv gravatar image

I would like alternate rows to have different background colour. I used conditional formatting to achieve the desired result by having a new style that had background colour defined for the cells. However, the problem is that the existing format of the cells get disturbed. e.g. if I have cells with zero decimal places, they get redefined with the number definition of the new style used for background colour fill.

Is there a way by which existing style gets used except that only the background colour is filled for alternate rows?

edit retag flag offensive close merge delete


Google spreadsheet provides a more user friendly conditional formatting process and wish the same is replicated here.

nv gravatar imagenv ( 2017-08-13 09:02:10 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-08-13 15:17:48 +0200

komma4 gravatar image

You can use a macro, to only set the background colour property.

see: colorCalcCellsSelection as an example.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-13 08:29:08 +0200

Seen: 476 times

Last updated: Aug 13 '17