» 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:
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Microsoft Excel 2002 Formulas (With CD-ROM)
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Writing Excel Macros with VBA, 2nd Edition
- The Fall of Advertising and the Rise of PR
- Special Edition Using Microsoft Word 2002
No comments have been submitted.
