» 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:
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Windows XP for Dummies
- Microsoft Access 2002 for Dummies
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
No comments have been submitted.
