To apply the shading to a specific range of cells, select the cells you want to format.On the worksheet, do one of the following:.The formula is shown here: =MOD(ROW(),2)=0

This rule uses a formula to determine whether a row is even or odd numbered, and then applies the shading accordingly. Technique 1: Apply shading to alternate rows by using conditional formatting One way to apply shading to alternate rows in your worksheet is by creating a conditional formatting rule. Alternatively, you can apply a predefined Excel table style to your data. You can apply the shading by using a simple conditional formatting formula. Įxcel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 This article shows you how to automatically apply shading to every other row in a worksheet.

From here you can click the dropdown and adjust your styles in more detail.

Put =MOD(ROW(),2)=1 in the formula box.

Mac: Select “Classic” in the drop-down box and choose “Use a formula to determine which cells to format”.

PC: Select “Use a formula to determine which cells to format”.

In this MS Excel tutorial from ExcelIsFun, the 467th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting every nth value using the SUMPRODUCT, MOD and ROW functions. To shade alternate rows in Excel Mac OS X: - Open up your Excel document and highlight all your data - Go to Format toolbar, select Conditional Formatting and it will open up a text box.

Go to the main menu and go to–> Format –>Conditional Formatting.Click on one of the Tab Styles The Custom Way.Highlight the area you want to to apply the style to.Look at the tabs under the top toolbar.The Quick Way I feel that this way works best if you are starting from scratch, but you could apply it to an existing spreadsheet. Wish you could make your Excel spreadsheet a bit easier to read by coloring every other row? What if your spread sheet is huge and you don’t want to do it by hand? There are a couple ways to do this.

Shade every other row in excel for mac