Custom data label color based on another cell Value (Priority)

[SereneSea]

Good morning,
Another question on my mind. Is there away to have data lables automatically change color based on another cell? I have a gantt chart and for high priority status (Column I) i would like the labels to change colors to be easier seen. I realize I can do this manually but this chart will be populated by many users so I want to ensure same formatting for high priority.

Thanks in advance!

 

[ebea]

This screendump you show now in #10, has nothing to do with this you uploaded in #7. So it's difficult to know, what you actually want. I can't see it.
You start writing it was in a Gantt Chart. But this you uploaded, has nothing to do with a Gantt Chart, which normally are filled with conditional formatting, and build in a fully other way.
This you uploaded, are normally formulas, which can be conditional formatted, on a normally condition.

So I stay out, until you give some clear info, and data, what it is you want.