I am struggling to count the yellow coloured cells in the rows.
| NewPivotUdemy.xlsm | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | 13 | 4 | 2 | 9 | 3 | 4 | ||
| 2 | 16 | 1 | 1 | 10 | 11 | -5 | ||
| 3 | 14 | 2 | 4 | 7 | 7 | -22 | ||
| 4 | 10 | 2 | 3 | 8 | 10 | 18 | ||
| 5 | 7 | 2 | 5 | 5 | 8 | 6 | ||
| 6 | 4 | 7 | 11 | 5 | 2 | -21 | ||
| 7 | 9 | 2 | 6 | 4 | 9 | 1 | ||
| 8 | 1 | 6 | 11 | 1 | -5 | |||
| 9 | 12 | 8 | 9 | 2 | 3 | 3 | ||
| 10 | 10 | 8 | 8 | 3 | 6 | -14 | ||
| 11 | 18 | 5 | 10 | 1 | 5 | 10 | ||
Sheet3 | ||||||||
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| F1:F11 | Cell Value | <0 | text | NO |
| E1:E11 | Cell Value | between 1 and 3 | text | NO |
| B1:B11 | Cell Value | between 1 and 2 | text | NO |
| D1:D11 | Cell Value | <5 | text | NO |
| C1:C11 | Cell Value | between 1 and 3 | text | NO |
| A1:A11 | Cell Value | between 1 and 12 | text | NO |
