I need to conditionally format a cell in 6 colors. So if the cell contains r,
it gets red, g it gets green, etc for blue, grey, yellow.

I only see 3 possible conditional formats (or 4 with the default).

Is there anyway around this? Can I make a formula that would copy some other
cell, formatting and all, to the cell?

Side question: Is it possible to put a picture behind the cells so it shows
up on the screen (i.e. not header or footer.)