Conditional formatting a field based on 5 variables

Anonymous Here is my approach
1. Go to edit query
2. Select all five fields and click on add column tab

3. Click on statistics and select count values
4. Close and apply

5. Right click on the name field in table visual 

6. Do the conditional formatting --> format by rules and  based on the new count column created using statistics

7. create rules for green red and yellow

Let me know if you have any question. If this post help mark it as solution.