Conditional Formatting a gantt chart

Hello all, I have a call out for help. I have a Gantt Chart that I have modified. I am trying to get some conditional formating done and need some help with the formulas. let me explan

I have the conditional formatting highlighting the current week. All the purple are items that are in need of service and the dates of service.

I would like the purple boxes to show up green IF there is the Letters "PM" in column D and on the same line as the purple blocks. Please let me know if you need any more clairification. I have attached some Pics. 1.png2.png

Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet.

A sample sheet would help here

The forum does allow for spreadsheets to be uploaded direct to the forum -

Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Here are the instructions, found at the top of the page again

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.