Conditional Formatting Multiple Conditions

[Lisa James]

Hi There. I have a column where I am trying to highlight dates that are past due. In column A is the due date and in column B is the date that it was done. What I need to do is highlight the dates in column A if they are past due and if column B is blank. If they are past due, but column B has a date listed, then I do not want it highlighted. I tried using multiple rules in the formatting, but cannot seem to get it right.

Please Help!

Thanks!

[wallsp]

Conditional Formatting
Use a formula to determine which cell to format

=AND($A1<TODAY(),$B1="")
select your fill color
apply to column A

[wallsp]

If you're using a table or add a filter to the header, you can filter by color, finding just the past-due invoices. Can make life easier.