Color code Gantt bar

Esperanza Zagal

Hi there!

I'm looking to code the color of Gantt bars based on the value of a different colum, called "Location". Is there a way to do this?

Thank you,

Esperanza

Andrée Starå

Hi @Esperanza Zagal

Yes, you'd use the Conditional Formatting feature.

Apply Formatting Automatically with Conditional Formatting Rules | Smartsheet Learning Center

https://help.smartsheet.com/articles/516359-conditional-formatting

Conditional formatting rules apply formatting automatically to rows or cells based on the values they contain.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Esperanza Zagal

Ah! Thanks! This helps.

Andrée Starå

@Esperanza Zagal

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!