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...
Thanks!Doug_Robbins_Word_MVP I had to change the >1 ti >2, but this was just what I needed.
- That would not result in the cell being shaded Red until a student was scheduled on 3 days whereas your original requirement was to detect if a student had been scheduled twice.
- You're right, I just discovered that, thanks.
