Using IF statement based on cell color for multiple cells to write one of many outcomes.

Copper Contributor

Sorry for the confusing subject line. That is the best way I am able to explain it. 

 

I am trying to create an auto schedule for employees based on the color of the cells. When a cell under an employee is blue I would like their name to be put in the schedule on another worksheet corresponding to that time block. With multiple names being able to be placed in the same time cell. 

 

I have attached a test document so you can understand it better. 

 

Thank you for the help. 

 

 

1 Reply