» Coloring Even Numbered Rows in a List
CATEGORY - Excel Format
VERSION - All Microsoft Excel Versions
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:
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Accounting the Easy Way
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
Coloring Even Numbered Rows in a List tip
jaaltonen
I've seen slightly differend versions of this tip on various forums, but never managed to make it work.
Fix missing parts of hint
Alsatian
Original tip missing some key pieces. Here's the fix.
Conditionally format one cell, e.g. cell "D11". The forumula in the formula box should be: =MOD(ROW(D11),2)<>0
Notice the insertian of D11 into the formula since you're formatting the D11 cell. Make sure to take out any $s and quotation marks which Excel likes to default to.
From there, use Paste Special...Formts to paste the conditional formatting to all cells. WARNING: this will overwrite any already existing formats e.g.number type
Select Area, Change Formula, Works Great!
Reed Marvin
In Excel 2002, I selected and area, followed the instructions with the exception of changing the formula to just:
=MOD(ROW(),2)
(notice I dropped the 0 from the end)
It worked great!
