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
Thank you. I'll play a bit with the file and answer
Thank you :)
Im not sure if it will make a difference.. but the employee lists in reality are far larger and could have 30- 50 employees per contractor. Just incase there is a limit on some rules, somehow...
