I have a sheet called "data" and in it there is a range of cells named "players". Some of the cells have a background colour of red (due to being sent off).

On Sheet called "Players" I want a column that counts the number of times a players name has a red background in the data sheet.

For example:

Sheet "Data"
Range "players"


Sheet "Players"
Cell "Z1" has the player name "Jones.J"
in Cell "AA1" I want it to count the number of times "Jones.J" appears WITH a "red" background in the datasheet "data" in the range "players".

Is this possible?
if yes .. How?
Please.