As The last ship sailed towards the distant horizon I sat there watching on a rock My mind slowly drifting away Forming into my... Dreamtale
How to Automatically Alternate Row (or Column) Colors in Google Sheets
2018-01-25 / 2 min read

Applying some color to alternating rows in a spreadsheet can make it easier to read. Of course, you could manually change the background color of columns or rows, but who has time for that? So here’s how to use conditional formatting to automatically create a colorful and attractive spreadsheet in Google Sheets.

  • In Google Sheets, head up to Format and click on Conditional formatting.
  • Select “Add new rule.” Select the range using the “Apply to range” field, and then under the “Format cells if…” dropdown menu, select “Custom formula is.” Then, there are four basic rules you can create here to dictate how and where you’d like color applied to your sheet.
  • To apply a color to all even rows, type =ISEVEN(ROW()). To apply the rule to odd rows, type =ISODD(ROW()). Click the paint bucket icon to change the color.
  • To apply color to all even columns, type =ISEVEN(COLUMN()). To apply the rule to odd columns, type =ISODD(COLUMN()).