Formulating a complete date by Due date

I have tried just about everything I have read and can think of and need your help.

I have an excel spreadsheet with a list of task that contain due dates and completion dates, I am trying to formulate the complete date column with color coding if task was completed after the due date.

Or any other suggestions is greatly appreciated.

Any help or suggestions is appreciated.
Thanks