change particular bars in bar chart as per value contains in that column

Version 1

    Hi All,

     

    I am new to this tableau world. I need you help to learn tableau. I am preparing monthly productivity dashboard. In my data I have employee columns and their productivity details. In employee column there are some employee names. There are some employees they do support. So in my bar chart where ever employee's name contains Support then the bar should be Red Color and rest of bar should be same color.

     

    Can any one help me with this questions.

     

    Regards,

    Pradeep