G
Guest
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.)
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.)