Good afternoon
I have a worknbook
what I need to do is change for example person2 in cell A5 to red, amber or green based on the reports submission


so I have person 1 in A5


I want him to change his name (cell a5) to red if he has ANY value in L5 M5 R5 S5 Y5 Z5 AF5 AG5, these are numbers based on reports so could be any amount.

I have tried conditional formatting but it says it doesn't work

is this possible?
Thanks
Chris