XL97: Conditional Format Applies Format for First Condition

MORE INFORMATION

The following example applies two font formats to cells based on two conditional formats.

Conditional formatting checks the first condition and applies it to all cells that meet the condition. Microsoft Excel checks the second condition and applies it to all cells that meet the condition and cells that were not part of the first condition.

1. Enter the following in a new worksheet:

   A1: 1
   A2: 2
   A3: 3

2. Select cells A1 through A3.
3. On the Format menu, click Conditional Formatting.
4. For Condition 1: Click in the first box and click "Cell Value".
5. Click in the second box and click "Greater than".
6. Click in the third box and enter the number 2.
7. Click Format.
8. On the Font tab, change Color to red.
9. Click OK and then click Add.
10. For Condition 2: Click in the first box and click "Cell Value".
11. Click in the second box and click "Greater than".
12. Click in the third box and enter the number 1.
13. Click Format.
14. On the Font tab, change Color to blue.
15. Click OK and then click OK again.

Cell A3 has a font color of red because it meets the first condition. Cell A2 has a font color of blue because it meets the second condition. In cell A3 the second condition is ignored because it already met the first condition.