Conditional formatting of task bar for 'Assigned to' containing two names not working

I have conditional formatting to give each person a different color on the task bar. Some tasks are assigned to more than one person, eg Mark and Fred. It's not working to format a different color for tasks assigned to Mark AND Fred.

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 05/11/20

    Hi Mark,

    At this time Conditional formatting is only able to look to see if a cell in a Contact column contains either this name or that name, but cannot read a combination of two names as one unique value. Therefore, if you have two names selected in one cell, the formatting will display whichever name is highest in your Conditional Formatting list (as that will be the first rule applied).

    Please submit an Enhancement Request when you have a moment!

    If the colour change is important, we could potentially include a Helper Column in your sheet which assigns a specific number to each possible combination of names selected. (Ex, "Mark & Fred" = 1, "Mark & John" = 2, "John & Fred" = 3... etc)

    You could then have your Conditional Formatting rules be based on this helper column looking at the different numbers, in addition to looking at the names. If you only have a small number of names and possible combinations this could be a good solution, but if you have many possible combinations it could get a bit complicated. Let me know what you think!

    Cheers,

    Genevieve