Sign in to submit new ideas and vote
Get Started

Conditional Format For "Task Bar" independent of "Entire Row"

My use case I have rules for various rows based on the Issue Type and I want a rule for the Task bar based on the status of the issue. For example, I want an Epic to show up with a Grey background, but I do not want the grey background to extend into the Gantt Chart but I want the Gant chart to show up as Green if the task is complete and Blue if it is in progress.

3
3 votes

Idea Submitted · Last Updated

Comments

  • This is currently not possible with a single rule but I have found a pretty easy/simple workaround for this using two rules:

    -Make a conditional formatting rule that formats only certain columns in the source grid

    -Clone the rule

    -In the cloned rule:
    -Change the target to the entire row
    -Reset background and text settings to defaults
    -Change the task bar setting to desired color

    For my use, this is what my conditional formatting rules look like:

    And this is how the Gantt looks: