i have a spread sheet for a lottery syndicate by entering the winning numbers and suplementry numbers the numbers in the rows change colour Each row is a seperate game and i have about 280 rows With the weekly drawn numbers the cell turns green and if the game contains those numbers and blue for the suplementry numbers Im looking for a way to auto count the blue cells and seperatly count the green cells in iach seperate row and place the tanny into the matching coulered cells in column K & L is it possible to come up with a solution to achieve this outcome Ihave included a dropbox copy of the sheet below

https://www.dropbox.com/scl/fi/lfp78z01qrstolvp23d0s/work-in-progress.xlsx?rlkey=jhlvy03wjyhdgirkpe75u3hpn&dl=0