Hello all,



I have a workbook that contains about 6 printable pages and one raw-data page. The people that are on my list are assigned a color-group at work, but they change out pretty frequently so I have the workbook set up to reference the raw data, and make up the print-sheets automatically.

One of the cells in the raw-data sheet says the name of the color assignment (ie; Yellow), and I would like to use this information to format the fill-color of the appropriate cells in the print-pages. I don't want the word "yellow" to appear on the print pages, but I want the data in that person's row to appear with a yellow fill.

Multiple cells with multiple data types will reference this color field, so I can't just have it conditioned to say "fill yellow if name = John"... instead I'd like that person's name, room number, job code, etc, all to fill yellow by having the cells look to see what color is listed for that person.

Any ideas? I've tried some things with conditional formatting, and while I do have the idea that the answer lies somewhere in the "formatting based on a formula" section, I can't figure out how to make it work.

Thanks!
~Joe