I want to use a cell containing a sheetname to dictate the color of the
cell next to it.
For info on how to use cell input to reference a worksheet See:
http://groups.google.com/group/micro...9ac44b4b25ec88

What I can't find is any info on how to change the color of a cell
based on the color of another cell.

I have 50+ rows each with a set of cells similar to this:
[____C____][_____D_____]
[blue cell ][''Sheet-1' ]
[red cell ][''Sheet-2' ]
[colored cell][''SheetName']
[colored cell][''SheetName']
[colored cell][''SheetName']
[colored cell][''SheetName']
[green cell ][''Sheet-26' ]
....

On just as many sheets I have a single cell that matches that color.
The cell is always in the same location. (A2 I think.)

How can I make the colored cells update based on the name of the sheet
they are associated with?

I've tried using a camera object but I can not copy it down to the next
row and have it reference the coresponding cell in that row without
creating a new object each time with a new formula. Beyond that it
doesn't even seem to work 100% ie. it doesn't change when the sheet
name does after it's initially created.


Any ideas?