» Coloring Even Numbered Rows in a List
CATEGORY - Excel Format
VERSION - All Microsoft Excel Versions
To color even numbered rows:1. Select a cell in the region and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A) to select the Current Region.
2. From the Format menu, select Conditional Formatting.
3. For Condition 1, select Formula Is, and insert the following formula in the Formula box:
=MOD(ROW(),2)0
4. Click Format, and select the Patterns tab.
5. Choose any color, and then click OK twice.
Book Store:
Recommended Books:
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Advanced modelling in finance using Excel and VBA
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
No comments have been submitted.
