Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I assume you mean alternating row colors?

  1. Create two cell styles
  2. Select area that should be formatted
  3. Format > Conditional formatting > Condition
  4. Select "Formula is" and type =MOD(ROW();2)

I assume you mean alternating row colors?

  1. Create two cell styles
  2. Select area that should be formatted
  3. Format > Conditional formatting > Condition
  4. Select "Formula is" and type =MOD(ROW();2)
  5. Select the cell style
  6. If you want a second color, add another condition
  7. Select "Formula is" and type =NOT(MOD(ROW();2))
  8. Select the cell style