Help with tricky conditional format

[AdeMolloy1980]

Hi,

Hoping somebody can help me. I have a large excel sheet that i use to track forecast delivery dates. The columns are split into multiple dependencies (one column has the forecast date and the column to the right of this has the actual date). I am trying to use a conditional format that can pick out dates that are overdue and fill it with colour when the cell in the column to the right of it is blank.

So if A1 has a date (or no date) and this date is in the past AND then if B1 is blank fill A1 with Amber etc.

I hope that makes sense but basically i want to format the entire sheet of dates and try to highlight where a forecast date is overdue and the actual date in the column to the right has not been claimed.

Thanks in advance.

[daffodil11]

Formula:

=AND(OR(A1="",A1<Today()),B1="")

Fill as needed

[AdeMolloy1980]

Thanks daffodil11 - this worked perfectly!