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 there a formula I can use for this?
| Student | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY |
| John Smith | x | x |
7 Replies
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.
