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 contractor.
EG
A1 - Business 1
A2 - Employee 1
A3 - Employee 2
B1 - Business 2
B2 - Employee 1
B3 - Employee 3
and so on.
On the roster sheet i would like the cell where names are inserted to automatically change color depending on what business they are from
Eg
24/10/17
B2 Employee1 (Turn Grey)
25/10/17
B1 Employee 5 (Blue)
my Issue is that i cant make the conditional formatting reference to an entire set of data in the column on the other page (B1 through to B17 for example) without getting errors.
How would i go about this?
Kind regards,
15 Replies
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
