Hello,
Solution 1: Reusable - Define your own Auto format
A1:D1 and set the color (e.g. white)A2:D2 and set the alternate color (e.g. grey)A3:D3 and set the color (e.g. white - step 1 needs to repeated here)A1:D4 (important to have on uncoolorized line) Format -> AutoFormat StylesAdd - button, and deselect every option but not PatternOKNow you can use this Autoformat for any arbitray range (Selecting the range) and using Format -> AutoFormat Styles
Solution 2: - Use Conditional formatting
MOD(ROW(),2)=1 - Apply Style 1 (BGWhite)MOD(ROW(),2)=0 - Apply Style 2 (BGGrey)Drawback of this solution: Conditional Formats take precedence over direct formats.
Update to Solution 2 - related to comment of OP
For each cell, two conditions need to be specified. One if the row of the cell is even and one, if it is odd (see also answer of @erAck - while his solution uses functions ISVEN(),ISODD(), my solution makes use of MOD() function
Hi Does not work for me?!
Solution 1. When i go to menu: Format -> AutoFormat Styles I can not klick Add?! (greyed out...)
solution 2: Nothing happens to my cells?
Should the formula be the same for condition 1 and 2 ?! mod(row()0,2)=1
I can not understand why it does not work :-(
Joel
Solution 1: If you cannot use Add then you have not enough cells preselected and correctly formatted and you need more cells to fill so LibreOffice recognizes the pattern.
Solution 2: You obviously never used Conditional Formatting - See screenshot in my answer
Sorry for my comment - there was of course a typo in the original version and you are right that the conditions need to be different.
Just saw that Solution 1 had a typo too:
Select range A2:D4 (important to have on uncoolorized line) must read:
Select range A1:D4 (important to have on uncoolorized line)* - that's why you don't see Add button.
Updated Solution 1
Thanks, solution #1 worked for me and was very helpful. First it solved my issue with applying alternating row colors and second it teached how to create your own auto format style. Would like to upvote it but I'm lacking points. Just created this account to say thanks.
Use a conditional formatting with two conditions, one condition with formula ISEVEN(ROW()) applying a style with one color, and a second condition with ISODD(ROW()) applying a style with another color. Obviously does not adapt to hidden rows, only the row number is considered.
I spent 30 minutes doing this over and over and it does not work for me. Problem is it's hard to track all the changes and what people are doing to get it to work. A single entry showing exactly how it should be done wold very much be appreciated.
Asked: 2019-09-11 16:05:47 +0200
Seen: 11,061 times
Last updated: Sep 12 '19
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Your formula is incorrect.
You wrote:
mod(row()0,2)=1but should readMOD(ROW(),2)=1and important: I'm not aware where you from, so two others things are important:;instead of,(English)Since this is an English site, I do use the English delimiter and English function names.
From what I see Villkor is Swedish for Condition and if I set my LibreOffice language to Swedish, then indeed it tells me that the delimiter in Swedish is
;: Thus:MOD(ROW();2)=1etc...