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

New 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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies