Conditional formatting based on when a cell has changed colour

hi there

i am a bit stumped with this one, cant seem to get my head round what i need to do.

i have a lottery spreadsheet at work and when i fill the drawn number below it colours the numbers above in green, i have done this witha formula in the conditional formatting. what i want to do now is when all ten numbers are coloured green make the persons name go green as well.

Capture.PNG

the formula i have in my formatting is =IF(COUNTIF($C$36:$H$489,C1)>0,TRUE) i have tried to adapt it but its not worked so far

regards

Michael

Thanks for the title change

to start with, you can shorted that CF formula from...
=IF(COUNTIF($C$36:$H$489,C1)>0,TRUE)
to...
=COUNTIF($C$36:$H$489,C1)>0

next, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.