Conditional Formatting That References Two Separate Conditions

I am trying to use conditional formatting in Excel 2003 to indicate when certain tasks are overdue (by highlighting the cell in red). My problem is that I have multiple criteria. If my line item is a "priority" item, it is considered aged if not resolved after 2 days; if the line item is "routine", the item is not considered aged until after two weeks (14 days). My goal is:

1) I would like the "status" cell in column D (which says "open" or "closed") to turn red if the item is aged.

2) Aging depends on the "priority" status in column A .......