Jan 10 2019 04:48 PM
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.
Jan 15 2019 09:07 AM
So I have found some more info. I have attached links and I think it might be the answer I was looking for.
https://excel.tips.net/T010779_Colors_in_an_IF_Function.html