Alternate Row Highlighting in Microsoft Excel
Often people overlook the importance of formatting documents. Spreadsheets are no exception so we’ve written a small tutorial on how to highlight alternate rows in Microsoft Excel 2007.
- Open the workbook (spreadsheet) and highlight all the rows.
- Select the ‘Conditional Formatting’ drop-down from the Home menu and select ‘Highlight Cell Rules’, then ‘More Rules’.
- Select the ‘Use a formula to determine which cells to format’ rule type from the list and enter the following formula to tell Excel to highlight alternate rows.
=MOD(ROW(),2)=0
- Select the ‘Format…’ button and set an appropriate cell style then hit the ok buttons.
- Your spreadsheet should now have alternate row highlighting.
