SOLVED

Conditional formatting - Mise en forme conditionnelle

New Contributor

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…

1 Reply
best response confirmed by ThereseSolimeno (Microsoft)
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.