I'm looking to write a conditional format.
If C3:I3 contains numbers, then B2 will replace the numbers. And so on down the list
If C3:I3 contains numbers, then B2 will replace the numbers. And so on down the list
| shift update - master.xlsm | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 1 | BODY PERSON (AM/PM) - Streetsville | ||||||||||
| 2 | BADGE # | NAME | Sat | Sun | Mon | Tue | Wed | Thu | Fri | ||
| 3 | 05143 | Ed Pavlovic | OFF | 0500-1500 | 0500-1500 | 0500-1500 | 0500-1500 | OFF | OFF | ||
| 4 | 05134 | Ricardo Correa | 0500-1500 | OFF | OFF | OFF | 0500-1500 | 0500-1500 | 0500-1500 | ||
| 5 | 03493 | Vincent Padua | OFF | 1430-2430 | 1430-2430 | 1430-2430 | 1430-2430 | OFF | OFF | ||
| 6 | 05235 | Joe Pavlovic | 1430-2430 | OFF | OFF | OFF | 1430-2430 | 1430-2430 | 1430-2430 | ||
Signup (ALL) | |||||||||||
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| C3 | Other Type | Color scale | NO | |
| C3 | Cell Value | ="0500-0600" | text | NO |
| G3:I3 | Other Type | Color scale | NO | |
| G3:I3 | Cell Value | ="0500-0600" | text | NO |
| D4:G4 | Other Type | Color scale | NO | |
| D4:G4 | Cell Value | ="0500-0600" | text | NO |
