Can you not do conditional formatting on a report that has a calendar?

mwb

I have a report that I made from pulling multiple sheets and certain columns, that I use as a calendar with the calendar view. I would like to color code the tasks on the calendar by project status, I saw that this is possible using conditional formatting or by clicking on the item in the Calendar view and changing the color. I have not been able to use any of those methods and was wondering if anyone had insight as to why. The conditional reporting button in my taskbar for this report does not appear, and when I click on the item in the calendar, it lets me change the content in the item but not the color.

Sameer Karkhanis

Conditional formatting is not supported in Reports.

Andrée Starå

Hi @mwb

I hope you're well and safe!

You'd have to add the conditional formatting in the sheet(s), which will show in the Report.

Would 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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!