Date changing and colour changing if overdue

Hello,

I've been struggling trying to sort out a datasheet for the last few weeks.

I'm trying to get it so that a date is entered into cell B, then cell C auto-populates a date 2 months later for review. Then when a date is entered into cell D (when review is done), cell C says "Complete" in green, but if no date is put into cell D after 2 months cell C will turn red indicating that it is overdue. Also want it so that when cell B is blank nothing is in cell C.

Is this even possible?

Thanks

In cell C (lets say it's C2)
=IF(ISNUMBER(D2), "Complete", IF(ISNUMBER(B2), EDATE(B2,2),""))

Look at Conditional Formatting to get your Green and Red Cells
http://www.contextures.com/xlCondFormat01.html
Does that work for you?

Glad I could help.