Hi Everyone! Happy monday?

I am trying to format a cell based on two factors. This excel spreadsheet is trying to track deliveries and dates. I would like to highlight a cell only if the date is in the last month and if the another cell is marked "No".

For ex. Column A has a list of dates. Column B is titled "Delivered" and Filled with Yes' and No's. A1 says 3/16/2012 and B1 says No. A1 should be highlighted. A2 also says 3/16/2012 and B2 says Yes. Even though the date is in the past it should not be highlighted.

How do I do this? I was trying to make a rule for it, but I could not figure that one out.

Thank you for your help.