Oct 16, 2014

How to Color Alternate Rows in Google Sheets

Microsoft Excel and other programs in Microsoft Office provide a handy feature called “Quick Styles” to help you quickly format a selected range as a striped table. The table can have zebra lines meaning alternating rows are formatted with different colors (see example).

Alternate Row Colors in Google Sheets

Google Sheets do not support zebra stripes (yet) but you can use conditional formatting combined with a simple Google Formula to create a formatted table. You can apply alternating colors to both rows and columns in Google Sheets easily.

Here’s the trick.

Open a Google Sheet and choose Conditional formatting from the Format menu. Select Custom Formula from the dropdown and put this formula in the input box.


Select a Background color for the rule and set the range in A1 notation. For instance, if you wish to apply alternating colors to rows 1 to 100 for columns A to Z, set the range as A1:Z100.

Click the “Add another rule” link and repeat the steps but set =ISODD(ROW()) as the custom formula and choose a different background color. Save the rules and the zebra stripes would be automatically applied to the specified range of cells.

Google Formulas with Conditional Formatting

Tip: If you wish to extend this technique to format columns with different colors, use the =ISEVEN(COLUMN()) formula. Simple!

This story, How to Color Alternate Rows in Google Sheets, was originally published at Digital Inspiration on 16/10/2014 under Google Docs, Internet

via Digital Inspiration Technology Blog http://ift.tt/1yH8LBO