Conditional Formatting Based on Content of Another Cell

I'm looking for a way to use conditional formatting to highlight when an invoice is overdue payment. In the attached sample spreadsheet, I would enter the date an invoice when it is received from a supplier (in column A) and then enter the date when it is paid (in column E). Is there a way to highlight the row if an invoice is over 2 weeks old according to column A, but ONLY if it has not been paid according to column E? Once a "paid date" has been entered I no longer want it highlighted to avoid confusion.

Thanks!

Select the table from top left of the data (A2) down to the bottom right, then apply the conditional formatting using the formula below.

Formula:

Please Login or Register  to view this content.

See attached.

BSB

Thank you so much for your reply! This works brilliantly! The only minor issue I have with this formula is it will highlight rows that are empty, is there anyway to avoid this?

Thanks so much for your help! That is exactly what I needed.

Glad we could help

BSB