In Google Sheets How to Color the Alternative Rows
Microsoft Excel and other programs in Microsoft Office provides handy feature called “Quick Styles” to help you quick format in a selected range as a striped table. The table can have zebra lines meaning alternating rows are formatted with different colors.
Google Sheets will not supports the zebra stripes but you can use conditional formatting combined with the simple Google Formula to create format table. we can also apply the alternate colors to both rows and columns in Google Sheets.
Here is the trick.
Once Open the Google Sheet from the Format menu and choose Conditional formatting . Select Custom Formula from the dropdown and put this formula in the input box.
=ISEVEN(ROW())
Select a Background color for the rule and set the A1 notation range. For Example, if you wish to apply the alternating colors to rows 1 to 100 for columns A to Z, set the range as A1:Z100.
Click the link “Add another rule” and repeat the steps but set =ISODD(ROW()) as the custom formula and choose a background color. Save the rules so that the zebra stripes would be applied automatically to the specified range of cells.
Microsoft Excel and other programs in Microsoft Office provides handy feature called “Quick Styles” to help you quick format in a selected range as a striped table. The table can have zebra lines meaning alternating rows are formatted with different colors.
Google Sheets will not supports the zebra stripes but you can use conditional formatting combined with the simple Google Formula to create format table. we can also apply the alternate colors to both rows and columns in Google Sheets.
Here is the trick.
Once Open the Google Sheet from the Format menu and choose Conditional formatting . Select Custom Formula from the dropdown and put this formula in the input box.
=ISEVEN(ROW())
Select a Background color for the rule and set the A1 notation range. For Example, if you wish to apply the alternating colors to rows 1 to 100 for columns A to Z, set the range as A1:Z100.
Click the link “Add another rule” and repeat the steps but set =ISODD(ROW()) as the custom formula and choose a background color. Save the rules so that the zebra stripes would be applied automatically to the specified range of cells.
Post a Comment