table1.JPG
Category color is Conditionally Formatted based on Text (i.e. cell color will change automatically with change of letter).

Goal: Automatically color each column in chart with same color as in category (based on Conditional Formatting).

chart1.JPG

Is someone out there that could help me to reach my goal?

arns