Mar 14 2022 08:44 PM
I do a lot of manual scheduling. I want to alert myself that I've scheduled somebody twice in one week. 2 X's turns the student's name red so I know I messed up (e.g. John Smith cell turns red). Is there a formula I can use for this?
Student | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY |
John Smith | x | x |
Mar 14 2022 09:50 PM
Mar 15 2022 01:47 AM - edited Mar 15 2022 01:48 AM
Thanks!@Doug_Robbins_Word_MVP I had to change the >1 ti >2, but this was just what I needed.
Mar 15 2022 02:27 AM
Mar 15 2022 02:44 AM
Mar 15 2022 02:55 AM
There's one more wrinkle. I have additional info in other cells that seems to be a problem with the COUNTA. I've set up a conditional formula so that anytime there's an X in D, F, H or J, the name turns green. But I want to set up an additional formula for those same cells so that if I do 2 X's (schedule somebody for 2 days by accident) the name changes red.
Mar 15 2022 03:20 AM
SolutionMar 15 2022 03:46 AM
Mar 15 2022 03:20 AM
Solution