How To Shade Every Other Row In Excel. Using the MOD formula. Navigate to the New Rules menu.
Therefore Excel will only apply formatting on the data when the formula is true Ie. Click and drag the mouse so that all cells in the range you want to style are highlighted. The More Colors button will provide more specific color options.
To highlight every other row of the entire document click the Select All button which is the gray square buttoncell at the top-left corner of the sheet.
Select format and in the Fill tab select the color youd like to fill with I usually select something here in the middle. Select Use a formula to determine which cells to format. Then a New Formatting Rule dialog box will pop out. It is simple versatile time-saving and has different designs that will give you different layouts.