SOLVED

Conditional formatting - Mise en forme conditionnelle

%3CLINGO-SUB%20id%3D%22lingo-sub-2196424%22%20slang%3D%22fr-FR%22%3EConditional%20fitness%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2196424%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3EI%20need%20to%20make%20a%20schedule%20of%2010%20speakers%20with%2010%20different%20or%20identical%20clients%20depending%20on%20the%20day...%2C%20I%20want%20the%20schedules%20to%20be%20spaced%2030%20minutes%20ranges%2C%20and%20that%20these%20ranges%20are%20%22colored%22%20according%20to%20the%20respective%20customers%2C%3C%2FP%3E%3CP%3EI%20was%20able%20to%20write%20a%20formula%20for%20a%20color%20to%20be%20present%20based%20on%20staff%20attendance%20hours%2C%20but%20I%20can't%20schedule%20several%20conditional%20formatting%20requests%20that%20work%20according%20to%20the%20client%20chosen.%20Is%20there%20a%20way%20to%20make%20the%2010%20queries%20for%20the%2010%20different%20customers%20show%20the%2010%20colors%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2196424%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EActivity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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.