Microsoft Excel Functions & Formulas

Use conditional formatting to shade project

steps with missed deadlines

The project schedule shown in Figure 10-19 contains different

steps and their starting and projected ending dates. The actual end

dates are listed in column E. Use conditional formatting to search

for all steps that ended late by comparing the dates in columns D

and E. As usual, select the desired formatting to apply when the

cell value meets the condition.

4

To shade project steps with missed deadlines:

1. In a worksheet, copy the values shown in Figure 10-19, and

select cells A2:E11.

2. On the Format menu, click Conditional Formatting.

3. Select Formula Is and type the formula =$E2>$D2 ...