Excelbud

I'm Excelbud, owner and site operator for Excelbuddy.com Thank you for visiting and feel free to explore.

This Excel function is very useful when dealing with long lists of data.  However, it is extremely easy to use once you know the simple formula.

1. First, start with a list. Select the complete list by left clicking in cell A2 and holding until cell A19.
   
2. Next, Select ‘Conditional Formatting’ located under the Format dropdown menu. Select “New Rule.”
   
3. From the “New Formatting Rule” box, select “Use a formula to determine which cells to format.” Once selected, enter “=MOD(row(),2) ” into the formula field as shown.
   
4. Next, click the Format button. Select a color and click OK.
   
5. The selected rows should now be formatted in an alternating color pattern. You are now able to insert rows without disturbing the formatting.