How to Color Alternate Rows in Google Sheets

The data you display via a spreadsheet document will be more attractive and more enjoyable to read by just applying different color between one row and another row below it. For instance, you can apply a soft grey on a row and a white on the row right below it, and repeat the same colors to all the next rows. Sounds simple, but it is much more attractive rather than black and white format.

In Google Sheets, you can apply the formatting like the scenario above easily. Google Sheets has a built-in formatting option that allows you to apply two different colors to two rows and repeat the colors to the next rows below them.

First, select the cells you want to apply the formatting to and click the Format menu and select Alternating colors.

As the Alternating colors panel appears, select the formatting style on the available options. By default, there are 12 formatting styles offered by Google Sheets. If you want, you can also use a different color on the header as well as footer. Simply click the Header and Footer options if you want to use different color on header and footer.

If the default formatting styles offered by Google Sheets don’t suit you, Google Sheets also allows you to set a custom formatting style. Click the “+” button on the Custom section within the Alternating colors panel and a new item will be added next to this button. Click the newly added item and set the the first color by clicking the bucket icon next to Color 1  and the second color by clicking the bucket icon next to Color 2. Click the Done button once you are done setting the colors.

Alternative way

In addition to method above, you can also use a formula to apply the formatting scenario above. First, select the cells you want to apply the formatting to and click the Format menu and select Conditional formatting.

As the Conditional formatting panel appears, click the drop-down menu below the Format cells if option and select Custom formula is.

Enter the following formula on the Value or formula field and click the Done button.

=MOD(ROW();2)<>0

Before pressing the Done button, you can also select the custom color by clicking the bucket icon and apply basic formatting like bold, italic or underline.

Related posts

Written by Haula

Music addict. Big fan of Inter football club



Leave a Comment

Your email address will not be published. Required fields are marked *