Change bar colors on Web Content Calendar View on Dashboard

Christina C

Hello, I thout it was worth a shot to post this again. I reached our last April with the same question and the one response I received did not fully understand what I was trying to do.

I have a Web published view of a calendar in a dashboard. All of the tasks bars (upcoming conferences) are orange. The calendar is based on a Summary report which is which is a roll up of over 50 conferences (summary metrics from each conference sheet).

I would like to change the color of some of the bars representing the conferences in the Web published view. Since I can not click and change there I have tried to go to each sheet and create a conditional formula to change the default color of the task bars there thinking they may role up. They do NOT.

I've tried to change the task colors everywhere I can an still they do not roll up. Should I just give up on this at this point?

Thank you for your assistance.

I have a calendar view on a dashboard for conferences that currently is a rollup of over 20 sheets (and growing) that roll up into a report which is published and then is a Web Content widget on the dashboard. Works great! I wanted to change the color for some of the conferences on the calendar to differentiate them. I understand that the report formatting comes from the underlying sheets so to set up the color on the calendar for a conference I would have to change the color of the task bars at the sheet level.

So I did that, using conditional formatting and the color is not changing for the conference on the dashboard calendar.

Here is a screen shots of the sheet with the conditional formatting where the color was changed:

On the report and the dashboard, it is not changing:

I can't understand what I am doing wrong. Could it have something to do with the fact that the task bars on the report/dashboard are derived from Sheet Summary start and end dates? If so, is there any way I can change the bar colors?

Any insight would be greatly appreciated! Thank you!