Good Morning.
I have the attached and wish to possibly count all or some of the cells that are formatted either by being bold, strikethrough, underlined, italic or coloured text / cell?
Is this possible using similar data to below;
I have the attached and wish to possibly count all or some of the cells that are formatted either by being bold, strikethrough, underlined, italic or coloured text / cell?
Is this possible using similar data to below;
Book2 | ||||
---|---|---|---|---|
B | C | |||
6 | Alex Tattersley1 | Man Utd | ||
7 | Alex Tattersley2 | Arsenal | ||
8 | Ants Farrell (AT) | Man Utd | ||
9 | Ben Cummings | Brighton & HA | ||
10 | Brandon Wilkinson | Arsenal | ||
11 | Chris Knutton (AT) | Man Utd | ||
12 | Craig Robbo (G) | Brighton & HA | ||
13 | Daniel Cummings | Arsenal | ||
14 | Danny Colbeck | Arsenal | ||
15 | Dave Crabtree | Newcastle Utd | ||
16 | Daz Hodgson | Man City | ||
17 | Dean Barrett1 | Arsenal | ||
18 | Dean Barrett2 | Brighton & HA | ||
19 | Elliott Kenyon | Brighton & HA | ||
20 | Gary Crabtree | Brighton & HA | ||
21 | Gavin West | Newcastle Utd | ||
22 | Geordie Watson | Man City | ||
23 | George Wilkinson (LW) | Man Utd | ||
24 | Glen Broadbent | Arsenal | ||
25 | Harvey Oakes | Man Utd | ||
26 | Jacob Colclough | Man Utd | ||
27 | James Pinder | Arsenal | ||
28 | Jamie Ballester | Arsenal | ||
29 | Joe McAdam | Tottenham | ||
30 | Joe Slingsby (AT) | Brighton & HA | ||
Sheet1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
B2:C30 | Expression | =ROW(B2)=CurrentRow | text | NO |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
C28:C30 | List | =$E$76:$E$96 |
C26 | List | =$E$76:$E$96 |
C22:C24 | List | =$E$76:$E$96 |
C6:C8 | List | =$E$76:$E$96 |
C11:C12 | List | =$E$76:$E$96 |
C17:C20 | List | =$E$76:$E$96 |
C14:C15 | List | =$E$76:$E$96 |