Excel使用vba按颜色验证

I need to check if a person (1, 2, 3, 4, 5) have authorization to use some product (A, B, C, D, E), so i have this: I need to check if a person (1, 2, 3, 4, 5) hav