Hi,
I have an issue that I can't seem to find anyone else having. Usually, when you want a cell's background-color to change depending on another cell's background-color, you can write "If A1 has .ColorIndex = 5, change to .ColorIndex = 5" for all the relevant colors, and then that does the job.
BUT, I need it to change to whichever color is the background-color of the cell, and not just some predetermined colors.
I'm making an pattern that includes 4 colors, and the cells for each color in the pattern (that I guess I can distinguish by writing 1,2,3,4 in them) should change when the color is changed in a "panel" containing 4 colors.
Just so you get the hang of it, I've made a smaller pattern and a panel on the left side, see the picture Screen Shot 2016-04-01 at 23.35.23.png
Bookmarks