Is there any way to make excel automatically change a cell's fill color if a
certain value is entered? I am making a schedule for employee shifts, and
would like to be able to have each person's name be associated with a color
without having to change the colors around each time I make a schedule.