I have a list of cells, currently in the range of C2:C24 in the
worksheet 'people'.
What i would like to do is have the cells in the worksheet 'schedule'
change to specific colors should the value in schedule equal a value in
the c2:c24 range of People. Each C# needs to be a different color.

Eg: worksheet: People
c2=qwe
c3=asd
c4=zxc
c5=poi
.....
if a value in schedule =qwe, i'd like it to be orange.
if a value in schedule =asd, i'd like it to be green.
exc...
i know this shouldnt be too hard and i could probably do a macro or
function that can compare the values in Schedule with the list in
People and when it finds a match picks up the formatting specified
(maybe a case statement?)

help/ideas appreciated

:)