Knight Technology Solutions

Excel: Highlight Every Other Row

1. First, highlight area you would like to highlight, or select the entire column.
2. On the Home tab of the ribbon (I'm using Excel 2010), click the button called 'Conditional Formatting'.
3. In the drop down, click on 'New Rule'.
4. On the menu screen that pops up, click on the last arrow that says 'Use a formula to determine which cells to format.
5. In the field labeled 'Format values where this formula is true', enter “=MOD(ROW( ),2)” Be sure to include the equals sign (=) and NOT the quotes("").

That did it for me! You can select what type of formatting you want on the last step of the process. To highlight the cells, pick a background or fill color.