» Coloring Rows Based on Text Criteria
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. In Condition 1, select Formula Is, and type =$C1="Amazon".
4. Click Format, select the Font tab, select a color, and then click OK.
5. In Condition 2, select Formula Is, and type =$C1="Intel".
6. Repeat step 4, select a different color than you selected for Condition 1, and then click OK.
7. In Condition 3, select Formula Is, and type =$E1="ExcelTip".
8. Repeat step 4, select a different color than you selected for Condition 1 and Condition 2, and then click OK twice.
Note:
Be sure to distinguish between absolute reference and relative reference when entering the formulas.


Book Store:
Recommended Books:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- How to Pay Zero Taxes (Annual)
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Investing for Dummies, Third Edition
No comments have been submitted.

