Then, select the Use a formula to determine which cells to format and use this formula: =MOD (ROW (),2)=0 or =MOD (COLUMN (),2)=0. Next, you can fill the rows and columns with your desired color.

How to Highlight Every Other ID in Excel. When reading across a wide list of data, such as an account ledger or product description list, it is easy to confuse the rows. This is especially true ...