Skip to content

LibreOffice Calc Alternate Background Row Color

Apply Alternate Background Row Color

  1. Select the range of cells that you wish to have alternating background colors.
    1. Left mouse click on the first desired cell in the range.
    2. Hold down the shift key then left mouse click on the last desired cell in the range.
  2. Use conditional formatting use one of the two directions.
    1. Menu Bar: Left mouse click on "Format" > "Conditional Formatting…" > "Condition...".
    2. Notebookbar: Left mouse click on "Home" > "Conditional Formatting…" > "Condition...".
  3. In the "Conditional Formatting" dialog.
    1. Under "Apply Style" left mouse click on "New Style...".
    2. In the "Cell Style" dialog.
      1. Under "Name" enter the desired style name (e.g. Alternate Background Color).
      2. Left mouse click on "Background" and then left mouse click on the desired background color (e.g. Light Gray 4).
      3. Left mouse click on "Ok".
    3. Left mouse click on "Cell value is" and change the selection to "Formula is".
    4. In the adjacent box enter without double quotes "ISEVEN(ROW())"
    5. Left mouse click on "OK".

Note

You can substitute ISEVEN(COLUMN()) for the formula and end up with alternating colored columns. You can also substitute ISODD(ROW()) to color the odd rows rather than the even ones.


Last update: August 9, 2020