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.

Q: I need to be able to easily color every other row in Excel 2003 and Excel 2007. Can you help me with this?

How to alternate row colors in Excel To apply color in alternate rows or columns in Excel, follow these steps- Open the spreadsheet with Excel. Select the rows and columns that you want to colorize.