» Coloring One Record in Each Group in a Range
CATEGORY - Working with Formulas
VERSION - All Microsoft Excel Versions
To color one record in each group in a range, use Conditional Formatting: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:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Microsoft Access 2002 for Dummies
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Absolute Beginner's Guide to Microsoft Excel 2002
- Analyzing Markets, Products, and Marketing Plans
No comments have been submitted.
