Index - color grey every other line?? [closed]

edit

Thanks @Lupp. Is that a Sub in Basic? Similar to Visual Basic in Excel? Cause I looked at your example but cannot see your Sub in Basic nor see any formula's in cells? I'm interested in understand how to duplicate what you did.

It's done by Conditional Formatting. Open the example and go Format > Conditional Formatting > Manage > Edit to see the conditional format(s) defined for the document. Each one consists of a Range(s) "name" and of one or more conditions selecting what named cell style (if any) is to be overlaid to the existing cell style / attributes for any cell in the Range(s) if it is in the view.
Doing something to a similar effect by user code is much more complicated and much less efficient.

There are also disadvantages of the method. In specific the CF ranges often get absurdly fragemented during development / design of the sheets. I would advise to clean CF up when the design is finished.

Thanks @Lupp, I have LO 5.3.4.2. windows 10. I got this warning when running the example. ...LibreOffice requires a Java runtime environment (JRE) to perform this task. Please install a JRE and restart LibreOffice... I will play with it in a later date, First chore will be to install JRE!