I have a project schedule template made using Conditional formatting rules.

What i would like to do is change the color of the bar based on the text under the Assigned to column

I got it from this Microsoft link. Simple Gantt Chart | Microsoft Create