Try this...
In Excel 2007
Select the range of cells. Assume this range is A1:A7
Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a
formula to determine which cells to format
Enter this formula in the box below:
=AND(A1<>"",A1<>"complete",A1<>"not started",A1<>"stalled")
Click the Format button
Select the desired style(s)
OK out
In Excel versions 2003 and earlier
Select the range of cells. Assume this range is A1:A7
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND(A1<>"",A1<>"complete",A1<>"not started",A1<>"stalled")
Click the Format button
Select the desired style(s)
OK out
--
Biff
Microsoft Excel MVP