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

I have an index where I would like to make every other line grey or whatever color I now want to make it easier to follow each line. I know there is something called Autofomatting...but I cannot figure out how you can create my own formats?

Anyone who has a script or know if it already exist in LO..then where can I find this option? I want to be able to apply it to the marked area of my choosing.

Maybe it is also called shading to alternate rows!

edit retag reopen merge delete

### Closed for the following reason question is not relevant or outdated by Alex Kemp close date 2020-07-20 12:40:27.558223

Sort by » oldest newest most voted

The standard solution is by Conditional Formatting in mode 'Formula is' and with condition ISEVEN(ROW()) or similar. Of course, you also need a cell style (derived from 'Default') for overlaying the different background color. See this example.

more

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.

( 2018-02-07 01:48:25 +0100 )edit

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.

( 2018-02-07 11:11:34 +0100 )edit

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.

( 2018-02-07 11:15:05 +0100 )edit

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!

( 2018-02-07 11:36:44 +0100 )edit

I guess I did it manually! :~) I formatted row 1 and 2, then highlighted row 1 and 2, copied them, then on row 3 hold down Shift then either arrow down, page down, or Crtl+Shift+down arrow, last option will take ya to the very bottom! Then Ctrl+v, or any other way you paste. Good luck. If ya want to just change format after you have a lot of data in cells, do same, only not just Paste, but Paste Special.

more