Color Row Of Overdue Invoice Dates

Hi All,
I'm trying to build up a spreadsheet with the info below to follow up the due and overdue invoices. My point is to highlight the whole row for an unpaid invoice at the due date.
Here's the basic structure of the document:
A colum: invoice ref
B : name of customer
C : Invoice date
D : Due date
E and F: Amount in EUR and USD
G : Paid (Yes/No)

1. I'd like to highlight the whole row in red when the invoice is due/overdue AND unpaid (G = No). That means 2 conditions.
2. When invoices are paid (when G = Yes), the row should be green.
3. Highlight the whole row in orange when the invoice is unpaid and due in 10 days.

Can anyone help?

TIA,

Nicolas

Re: Invoices Follow-up: Conditional Formatting

Hi,
Thanks for your replies.
I tried with the code below but I have an error message
=IF(AND($G2="Non",$D2 <=TODAY()), 1,0)=1

Problem is "Non",$D2 according to Excel.

Any clue?

Thanks,

Nicolas

Re: Color Row Of Overdue Invoice Dates

OK. Problem solved. It was only a delimiter problem.
Thanks again guys!

One more thing, maybe it has been mentioned somewhere else but I read somewhere Excel could send e-mail.
Is there a way I could set it up to send automatically an e-mail to a given adress (let's say an address in column X at a given time (let's say some 10 days before due date) ?
Do I have to write an e-mail template for this?

TIA,

Nicolas