Referencing a table or varying values to another table in the same sheet

(Excel Version 2602)

Hi all. Sorry if my question is too vague, I am trying to word it as best I can to get my problem across.

I am trying to reference a table wherein there’s varying values assigned to two variables that are deemed acceptable. (Basically, if a person has 0 violations and 0-2 accidents, they would be good/green. But if a person has 0 violations and 3 accidents, they would be considered bad/red, etc.)

I would like this to be reflected in a separate table on the same sheet that has these amounts listed (violations and accidents), and essentially give the columns the corresponding color that would match the thresholds in the table.

Is there any way to accomplish this easily or am I in way over my head? It will not let me attach pictures or copy them into the text so sorry for no reference photos

Thank you.