» 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:
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Guide to Financial Reporting and Analysis
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Investing in Real Estate, Fourth Edition
No comments have been submitted.
