How to return a value if a cell/ row coloured cell

[maddley]

Is it possible to return a value in a cell based on the number of coloured cells are in that row. For example if theres 2 coloured cells on the row of the players name under the column "no. cleaned" it would return the value 2.. etc

.

 

[etaf]

are you using conditional formatting to colour the cells
it maybe possible to use that rule to also count
other wise you will need VBA