Conditional formatting based on dates and blank cells

Hi there,

I am battling with this conditional formatting task I'm trying to sort out.

I have three DATE Columns: Initiated, Forecast and Complete

Question: How can i format the FORECAST column dates to change to red font once the date is passed IF there is no date entered in the COMPLETE column?

The intent is to easily identify tasks that are overdue and not complete.

I hope that makes sense and is relatively easy to fix.

I feel the "New Rule" function in Excel 2010 is not very user friendly, hence my struggles.

Cheers
FF

That is perfect. thanks a lot TV.
Cheers
FF

Example 2.xlsxExample 2.xlsx

Hey TV, hoping you can help me with something else after your excellent work on my last problem.

I want to create a drop down list in B3 based on the choice made from another drop down list in A3.
All options in both lists have more than one word in them.
I hope that makes sense.

I have had a look at dependent formatting but it is getting me nowhere.

Hoping to hear from you soon.

Cheers
FF

TV, you are a legend. I never would've figured that out. cheers and i'll give you some A+ feedback.