Conditional formatting

Alister

Hi All,

i wonder if there is a formula to help me out to change the task color bar match with my Assigned to column

Andrée Starå

@Alister

Happy to help!

You can use Conditional Formatting for the taskbar.

You can also automate it with a formula in a so-called helper column.

Make sense?

✅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!

Andrée Starå

Hi @Alister

I hope you're well and safe!

Here's where you change the Task Bar color.

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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!

Alister

Hi @Andrée Starå

Thank you so much for that, but i need formula to change task bar color base on assigned to color by it self

In conditionals format only option available its fir column nit task bar

Am I missing something in here 🤔

Alister

@Andrée Starå

Imagine I have to go to 1500 line and change it task bar one by one ,I'm looking for better way if there is

Thank you

Andrée Starå

@Alister

Happy to help!

You can use Conditional Formatting for the taskbar.

You can also automate it with a formula in a so-called helper column.

Make sense?

✅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!

Alister

thank you i got it :)

Andrée Starå

@Alister

Excellent!

You're more than welcome!