Formatting depending on value of other cell (date being within two weeks)

Hi
I have a spreadsheet logging activity on a number of audits, each audit has its own row.
One column lists whether we've received payment (Yes or No)
Another column lists whether they've completed their pre audit survey - left blank until they do, then we input the date completed (so would always be today or before today).
Another column lists the audit date.

I'd like the payment column's cell to be highlighted if it still shows 'No' when the audit date column shows a date either this week or next week.
And the survey column's cell to be highlighted if no date has been entered when the audit date column shows a date either this week or next week

I've been trying without success!
I can get the audit date to highlight if it's this week or next week, but not the other two as listed above...

Thanks!

Please post a small sample file illustrating what you require.


Click on "Go Advanced" then Paper Clip icon to "Add Files"