Here is my problem: I have multiple choices for each day of the week, 5 Mondays through 5 Fridays (morinings and afternoons too). I have tried several variants of Formula Is such that if each Monday morning is empty, or blank, then the conditional formatting will be for the cell on another worksheet to be filled in grey. I can do this for one choice but not multiple selections, anyone have an idea here?
The W/S that has to be greyed out if all 5 parts of a day are blank on the schedule will follow. Thanks.
| Muster 01.xls | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| D | E | F | G | H | I | J | K | |||
| 2 | DAYOFCLASS | BEGINTIMEAM | BEGINTIMEPM | ENDTIMEAM | ENDTIMEPM | AMHours | PMHours | SESS.HOURS | ||
| 3 | Mon | |||||||||
| 4 | Tue | |||||||||
| 5 | Wed | |||||||||
| 6 | Thu | |||||||||
| 7 | Fri | |||||||||
| 8 | Mon | |||||||||
| 9 | Tue | |||||||||
| 10 | Wed | |||||||||
| 11 | Thu | |||||||||
| 12 | Fri | |||||||||
| 13 | Mon | |||||||||
| 14 | Tue | |||||||||
| 15 | Wed | |||||||||
| 16 | Thu | |||||||||
| 17 | Fri | |||||||||
| 18 | Mon | |||||||||
| 19 | Tue | |||||||||
| 20 | Wed | |||||||||
| 21 | Thu | |||||||||
| 22 | Fri | |||||||||
| 23 | Mon | |||||||||
| 24 | Tue | |||||||||
| 25 | Wed | |||||||||
| 26 | Thu | |||||||||
| 27 | Fri | |||||||||
Sch | ||||||||||
The W/S that has to be greyed out if all 5 parts of a day are blank on the schedule will follow. Thanks.
