Filling color of a cell (not as easy as sounds)

Hello,

Thanks to this forum, I was able to solve my previous issue with my excel file, and I am now stuck in the second and last task.

Basically, what I want to achieve is this:

If (Name) in Sheet 2 is Level (n) in Sheet 1, fill (Name) cell in Sheet 2 with corresponding color

As soon as Person's name is set in Sheet 1, it will pop up in Sheet 2 at corresponding shift, and I want it to have its designated color based on its Level.

A picture should save a thousand words...
12.PNG
13.PNG

Also, please find the attachment for excel file!

Thanks