Due Date Conditional Formatting

[JamesW254]

Hi all

I am sorry if this has been covered before but I have searched past threads and have been unable to get this conditional formatting to work...

In the attached workbook I need to conditionally format the Target Date (Resolution) to a traffic light Yellow,Amber,Red based on the current date. However if the status is Closed it should not be Red even though the due date has passed because the case has been resolved.

I hope you understand what I mean.. I have been trying to do it myself now for an hour or so but haven't been getting very far.

Thanks,

James