RainerJonker
New Member
- Joined
- May 17, 2022
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
Is it possible to use a if statement to highlight all the the numbers bigger than row D red for rows E-V instead of doing it individually.
| Excersize.xlsx | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | |||
| 3 | |||||||||||||||||||||
| 4 | 01-May | 02-May | 03-May | 04-May | 05-May | 06-May | |||||||||||||||
| 5 | BUDGET PER SHIFT | MORNING | AFTERNOON | NIGHT | MORNING | AFTERNOON | NIGHT | MORNING | AFTERNOON | NIGHT | MORNING | AFTERNOON | NIGHT | MORNING | AFTERNOON | NIGHT | MORNING | AFTERNOON | NIGHT | ||
| 6 | 6 | 6 | 3 | 7 | 5 | 7 | 5 | 5 | 7 | 3 | 7 | 7 | 6 | ||||||||
| 7 | 7 | 7 | 9 | 4 | 5 | 4 | 7 | 5 | 4 | 4 | 3 | 5 | 5 | ||||||||
| 8 | 8 | 5 | 7 | 7 | 7 | 5 | 6 | 7 | 7 | 7 | 7 | 6 | 7 | ||||||||
| 9 | 7 | 7 | 8 | 7 | 6 | 5 | 6 | 5 | 8 | 6 | 5 | 3 | 9 | ||||||||
| 10 | 4 | 4 | 5 | 7 | 6 | 6 | 6 | 6 | 9 | 7 | 7 | 8 | 8 | ||||||||
| 11 | 4 | 4 | 6 | 7 | 7 | 8 | 6 | 5 | 9 | 7 | 8 | 8 | 9 | ||||||||
| 12 | 7 | 6 | 6 | 6 | 5 | 6 | 5 | 6 | 5 | 7 | 6 | 8 | 5 | ||||||||
| 13 | 8 | 1 | 5 | 6 | 7 | 6 | 6 | 7 | 9 | 7 | 8 | 5 | 6 | ||||||||
| 14 | 8 | 6 | 7 | 3 | 8 | 4 | 4 | 9 | 5 | 9 | 8 | 6 | 5 | ||||||||
| 15 | 8 | 7 | 8 | 3 | 9 | 6 | 8 | 8 | 7 | 8 | 8 | 4 | 7 | ||||||||
| 16 | 8 | 5 | 6 | 3 | 6 | 5 | 6 | 5 | 4 | 8 | 3 | 7 | 9 | ||||||||
| 17 | 10 | 7 | 7 | 4 | 8 | 4 | 7 | 7 | 8 | 7 | 6 | 6 | 7 | ||||||||
| 18 | 11 | 7 | 7 | 4 | 9 | 6 | 7 | 8 | 8 | 7 | 4 | 8 | 7 | ||||||||
| 19 | 7 | 7 | 0 | 1 | 6 | 3 | 7 | 7 | 7 | 7 | 5 | 8 | 7 | ||||||||
| 20 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 3 | 0 | 0 | 8 | ||||||||
| 21 | 5 | ||||||||||||||||||||
| 22 | 6 | 6 | 0 | 6 | 5 | 5 | 5 | 2 | 5 | 7 | 0 | 0 | 6 | ||||||||
| 23 | 8 | 6 | 3 | 4 | 3 | 4 | 4 | 3 | 4 | 7 | 7 | 4 | 2 | ||||||||
| 24 | 4 | 7 | 0 | 7 | 0 | 6 | 0 | 6 | 0 | 7 | 0 | 7 | 0 | ||||||||
| 25 | 4 | 5 | 0 | 6 | 0 | 4 | 0 | 2 | 0 | 4 | 0 | 4 | 0 | ||||||||
| 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | ||||||||
| 27 | 5 | 0 | 5 | 7 | 6 | 7 | 5 | 6 | 8 | 7 | 8 | 6 | 4 | ||||||||
| 28 | 6 | 6 | 8 | 5 | 8 | 8 | 7 | 9 | 9 | 8 | 9 | 10 | 5 | ||||||||
Data Input | |||||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D6:D11 | D6 | =Template!D5 |
| D12:D22,D24:D28 | D12 | =Template!D12 |
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| E20:V20 | Cell Value | >3 | text | NO |
| E17:V17 | Cell Value | >10 | text | NO |
| E14:V16 | Cell Value | >8 | text | NO |
| E13:V13 | Cell Value | >8 | text | NO |
| E12:V12 | Cell Value | >7 | text | NO |
| E10:V11 | Cell Value | >4 | text | NO |
| E9:V9 | Cell Value | >7 | text | NO |
| E7:V7 | Cell Value | >7 | text | NO |
| E6:V6 | Cell Value | >6 | text | NO |
