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