OK, I can simplify the problem a bit by using the color pallete I have
in the back as an index, but I still need a way to select and apply the
color of one cell to another one based on the text in the index cell.
I'm thinking somthing along the lines of a macro using format painter
called by the vlookup function.