» Coloring Rows Based on Text Criteria

CATEGORY - Excel Format VERSION - All Microsoft Excel Versions

To color rows based on text criteria:

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.
Screenshot // Coloring Rows Based on Text Criteria