Google Sheet - Gantt Chart Help

[ApriltheVA]

I hope someone can help me with the formula. I am creating a google sheet to outline task in gantt chart.
see link: The Power In You Unlimited - Projects Timeline

I have everything set up, but for the life of me, I can't get the formula to work to show the bars.
Conditional formula =AND(H$4>=$D6,H$4<=F$6)
But I also would like the bars color coded based on the category.

I hope someone can help me out on this. Thanks.

 

[Fluff]

You references look wrong, should it be
=AND(H$4>=$D6,H$4<=$F6)
If Sheets is anything like Excel, then you will need to create a rule for each colour.

 

[ApriltheVA]

The rule color works on Excel but not on google sheet.

 

[Fluff]

For the different colours you will need to use something like
=AND($D7="High Risk", I$4>=$E7,I$4<=$G7)

 

[ApriltheVA]

Thank you. I tried that formula but I know i typed it wrong.
I really appreciate you assisting me in this. I've been working on it for many hours.

 

[ApriltheVA]

If no one told you today, you are absolutely AWESOME!!

 

[Fluff]

You're welcome & thanks for the feedback.