Alternating colors

[eipapp61]

This is more a question, why don’t you folks make it as simple as Google Sheets and Microsoft Excel to set up alternating colors in calc ??? I really don’t understand why you have made it so damn difficult to do this in Libre. Even Zoho docs does it in a snap but with Libre you have to jump through so many hoops that it become discouraging. Oh, I know that for some it works just fine but surely you guys can do better and make it sooo much “simpler and easier” you know like the other guys do. That being the case, I would use Libre calc every single day but as it stands, I’ll stick with Google sheets, Excel or Zoho sheets.

Regards,
Bruce

[mariosv]

tdf#132780, Feature Request: Add Calc Tables with functionality similar to Excel’s “Format as tables”

[EarnestAl]

Make a selection, click Format > AutoFormat Style.

• Untick the boxes at the bottom except for Pattern and maybe AutoFit width and height
• Select something suitable, e.g. Simple Grid Rows
  
  
  
  
  

Or Select the range as before

• Click Format > Conditional > Manage > Add
• In the Conditional Formatting dialogue select Formula is.
  • Enter mod(row();2)
  • Select a suitable cell style, e.g. Accent 3, or make a new cell style
• OK, OK

That one is the method I have to use with Excel 2010

Spreadsheet with both methods
AlternatingColours.ods (8.8 KB)

[koyotak]

that’s bad cause conditioned formatted rows “accent 3” are dominant and do not accept any manually formatting that overwrite the condition.