Forum Discussion
Conditional formatting : Reference a list of names to change cell color.
Hello, Im in the process of redesigning a roster that involves employees from a number of different contractors. I have all employees on a seperate page seperated into columns based on the co...
Hi Kyriakos,
Better to have the sample, but in general the rule could be
=COUNTIF(<business list with employees>,<employee>)>0
one rule for each color (other words for each business)
Hi Sergei. Attached is the Test roster file.
I tried your rule i think how it was meant to be used, but did not work.
Thanks for your assistance