Conditional Format and Formula

[tryintogetpaid]

I have a spreadsheet that I am tracking offices that I audit. I am tracking what date the audit is sent out and if I get it back I am placing a DONE in the column next to the column with the date. For a visual:

2/8/08 DONE
2/1/08
2/3/08 DONE

ETC.

What I want, is the row that does not have DONE in column 2, if the date reaches past 2 weeks from the current date, it turns red and lets me know I need to contact that office. Conditional formatting would work but I can not do If Column D = DONE then Column C = format red. Any ideas?

[NBVC]

Select your range of dates in column C and go to Format|Conditional Formatting

Select Formula is from 1st drop down menu and enter formula:

=AND(C2<=TODAY()-14,D2<>"Done")

where C2 and D2 are top most cells in the range.