This fantastic tip creates alternating row colours in excel and, unlike other ways to do this, you don’t have to change the row colours every time you insert, delete, or move a row.
- First highlight the rows that you wish to apply the formatting to.
When the Conditional Formatting window appears, select “Formula Is” in the drop down. Then enter the following formula
mod(row(),2)=1- Click on the Format button and select the Patterns tab. Then select the required highlight colour.
Click on the OK button.