Would like to be able to conditionally format the wrapped columns as per the spreadsheet below, anyone with priority 1 should be highlighted, also the individual cells should be numbered. Of the 2 requests I've made, the first one is more urgent. Thank you.
| Football stats functions.xlsx | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | |||
| 1 | Name | Dept | Priority | Desired solution | |||||||||
| 2 | Tom | HR | 1 | 1 Tom | 1 Vic | 1 Jake | 1 Tom | 4 Vic | 7 Jake | ||||
| 3 | Jack | Sales | 3 | 1 Jack | 1 Mary | 1 Ted | 2 Jack | 5 Mary | 8 Ted | ||||
| 4 | Sam | Admin | 2 | 1 Sam | 1 Noel | 1 Ed | 3 Sam | 6 Noel | 9 Ed | ||||
| 5 | Vic | HR | 2 | ||||||||||
| 6 | Mary | Sales | 1 | ||||||||||
| 7 | Noel | Admin | 2 | ||||||||||
| 8 | Jake | HR | 3 | ||||||||||
| 9 | Ted | Sales | 1 | ||||||||||
| 10 | Ed | Admin | 2 | ||||||||||
Sheet25 | |||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| E2:G4 | E2 | =ROW(A1)&" "&WRAPCOLS(A2:A10,3) |
| Dynamic array formulas. | ||
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| E2:G4 | Expression | =C1=1 | text | NO |
