I use a word table to track project updates, The fields are "entry
number", "project", "date", and "notes". The table get reviewed by
quite a few people and I have a legend at the bottom of the table that
shows the color for each project. I would like to be able to enter the
project in a cell and have it automatically enter the color code for
that project. I know I can do this with Excel but I found it easier to
use Word for this process as the table is heavily text oriented.

thanks