I think the problem I am running into is the coding around looking at a
particular cell and determining the color of that cell and then
applying that color to a specific location in the Master workbook.
That is where I need to start. These people want everything based on a
color coded scheme. Also, I need to figure out how to allow only 6
colors for a cell. Gray, Red, Blue, Green and Yellow (and the
defaulted White).

If anyone has thoughts / sample code it would be GREATLY APPRECIATED!!!

Thanks!