September 11, 2009

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.

1. First highlight the rows that you wish to apply the formatting to.

2. When the Conditional Formatting window appears, select “Formula Is” in the drop down. Then enter the following formula

   mod(row(),2)=1

3. Click on the Format button and select the Patterns tab. Then select the required highlight colour.

4. Click on the OK button.

Software


Previous post Zanzero for coffee. And upholstery Zanzero for coffee. And the upholstery isn’t bad. Next post Sunday Morning A good cup of Illy coffee… Eels’ Blinking Lights and Other Revelations on the hi-fi… A fragile peace accord brokered between the warring offspring…