» Coloring One Record in Each Group in a Range
CATEGORY - Working with Formulas
VERSION - All Microsoft Excel Versions
1. Select the range of cells (or select the entire column).
2. From the Format menu, select Conditional Formatting.
3. In the Condition 1 box, select Formula Is.
4. Enter the following formula (make sure you are careful about the Absolute and Relative references): =COUNTIF($A$2:A2,A2)=1
5. Click Format, and select the Patterns tab.
6. Choose any color, and then click OK twice.

Book Store:
Recommended Books:
- Microsoft Windows XP Inside Out
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Business Plans For Dummies®
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
No comments have been submitted.

