| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| L6 | L6 | =IF(ISBLANK(G6), "At Work", "") |
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| A5:BD91 | Expression | =OR(ROW()=CELL("row"),COLUMN()=CELL("col")) | text | NO |
| E3,K6:IV91 | Cell Value | contains "PDR" | text | NO |
| K6:IV91,E2 | Cell Value | contains "FAN" | text | YES |
| K6:IV91 | Cell Value | contains "FSL" | text | NO |
| J1:J4,H:I | Cell Value | contains "MST" | text | NO |
| J1:J4,H:I | Cell Value | contains "MSC" | text | NO |
| K6:IV91,F2 | Cell Value | contains "FSK" | text | YES |
| H8:I8 | Cell Value | contains "MSM" | text | NO |
| J1:J4,H1:I7,H9:I65536 | Cell Value | contains "MSM" | text | NO |
| 5:5 | Dates Occurring | today | text | NO |
| A6:J91 | Expression | =ISBLANK($G6) | text | YES |
