Additional CBA code to format date range

Hey guys!

I'm working on a project planning-sheet and I have asked this forum for help two times before, succesfully.
Today, I am reaching out again and I think it's for the last time.

Everything is working as I want it to, except for the following: as you can see in the 'Projects'-tab a project has 3 dates: a starting date, an ending date and a date that a project starts its engineering (preperation phase). In combination with conditional formatting, I made sure that the row gets filled black when an 'x' is entered in column G, this shows the start phase through the end phase.

Now, I want to mark the start engineering through start phase. So for project 1, this should be 2022-05 until 2022-09. It would be perfect if the marking could have a pattern (like this https://software-solutions-online.co...-fill-pattern/).

How do I make this? Please let me know if I'm not clear. Thanks in advance!

Originally Posted by JeteMc

Perhaps this will help:
1. For the preparation phase use the following formula as a conditional formatting rule: =AND($A2<>"",I$1>=INDEX(Projects!$C$2:$C$18,MATCH($B2,Projects!$B$2:$B$18,0)),I$1<INDEX(Projects!$D$2:$D$18,MATCH($B2,Projects!$B$2:$B$18,0)))
2. For the start through end phases use: =AND($A2<>"",I$1>=INDEX(Projects!$D$2:$D$18,MATCH($B2,Projects!$B$2:$B$18,0)),I$1<=INDEX(Projects!$E$2:$E$18,MATCH($B2,Projects!$B$2:$B$18,0)))
Let us know if you have any questions.

Thank you very much! This works perfectly!