Calc: How to get Lines with slight alternate shading - which MacOS Numbers does routinely, possibly as a default

[DinoNerd]

The attached screenshot is a section of a spreadsheet imported from Numbers. The wider rows alternate white and a light grey, making it easier to follow the same line across a wide table. These rows came from numbers. The narrower, all white lines are all I can get Calc to produce.

I can fix the width (individually, line by line).

What I can’t figure out how to do is get the alternating line effect in a document either created in Calc or imported from Numbers via excel file format.

I’d really appreciate if someone could tell me how to make this happen. Calc can obviously do this, but where and how do I tell it to do so? (If I knew what the effect is called, I’d have more luck searching.)

![Screenshot_20260217_141638|690x238](upload://vHR5kL3TyRBbHBE7zAO0re9kLsT.png

[DinoNerd]

I tried using insert a line in the midst of the alternate colour area, and it appeared the same colour as its neighbour. Precisely what I don’t want. Even inserting 2 lines (via selecting 2 lines, one of each colour, then selecting insert) didn’t insert a pair of similar lines - they all echoed the colour of the nearest neighbour.

[clear]

I’d like make use of the feature you are describing. Short of that, there is

Tools > Options > Calc > View > Highlight row/column

[clear]

there is this solution using conditional formatting ISEVEN(ROW()) and ISODD(ROW()) by @anon73440385 from 2020:
.
https://ask.libreoffice.org/t/53045/2
.
and @EarnestAl autoformat solution here:
.
https://ask.libreoffice.org/t/53045/6
.
or
.
MOD(ROW(A1),2) here:
https://ask.libreoffice.org/t/53045/10

[DinoNerd]

Thanks. I might have known there’d be a built-in answer to the same basic problem, and it wouldn’t be the same as in Numbers.

[DinoNerd]

These look interesting. Experimentation time. Thank you.