Forum Discussion
Solved
Conditional formatting if multiple cells have an 'x' in them
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 t...
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.
- Worked, thanks!