Forum Discussion
sprintzian
Jan 11, 2019Copper Contributor
Using IF statement based on cell color for multiple cells to write one of many outcomes.
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.
- sprintzianCopper Contributor
So I have found some more info. I have attached links and I think it might be the answer I was looking for.
Colors in an IF Function
https://excel.tips.net/T010779_Colors_in_an_IF_Function.html