In MS Excel 2003
1. Select the entire table.
2. Goto Format – Conditional formatting
3. Select ‘Formula Is’ ption in 1st Dropdown
4. Enter Formula =Mod(Row(),2)=0
5. Select the color you want to fill every alternate row and click ok
Source: http://msexcelraj.wordpress.com/2007/11/11/excel-format-table-with-zebra-stripes/
Doesn't work like that in Excel 2010
ReplyDelete