Hi

I believe that we can do this, using gormulas and CF, but....mybe you need to re-look the conditions. What i mean is thet in H7, you wait to sat "Pending" And the Condition for Pending, must be 
IF(AND(B6<>"",F6=""),"Pending
F6 IS NOT Null(Empty)

And condition for "Complete", is this.

IF(F6<=E6,"Complete"
Which is the Corect, because F6 & E6 are same days..