Additional Conditional Formatting for Gantt Project Planner

[sjforti]

Hi all. I'm using the Gantt Project Planner template. I know how to edit the defined custom formatting. My question is whether I can go a level further.

For example, rather than just the one color showing the percent complete, if I add another column that shows the status, can I have the percent complete color update to a different color based on the status field? So whether the status column says red/yellow/green, or 1/2/3, or whatever, it can look at that value and change the color of the Percent Complete bar accordingly?

Thanks!