Conditional formatting - Mise en forme conditionnelle

[MichouJMY]

Hello,
I need to make a schedule grouping together 10 contributors to 10 different or identical customers depending on the day ..., I want the schedules to be spaced out by 30mn ranges, and that these ranges are "colored" according to the respective customers,
I was able to write a formula so that a color is present according to the hours of presence of the staff, but I cannot program several conditional formatting requests that work according to the chosen customer by displaying one color per customer. Is there a way to make the 10 requests for the 10 different clients show the 10 colors…?

I use Excel 2011 for Mac…

[#2 · Accepted solution]

I would recommend you use Outlook for this, or this sounds more like a scheduling app. Maybe look into the bookings.microsoft.com tool. We don't have any plans or features for this directly in Teams that I am aware of.