Need to know how to assign colors to different cells when a certain set of
initials are typed into a cell. I have 4 crews with 7 individuals and need to
keep track of pm's that are completed. Would like to set up so that a color
comes up for each crew.