Hello,
I want to "Change a cell value based on cell color".
And, if possible, "Change a range or group of cell values based on cell colors (that vary)"
The only reason I am looking to do this is because I cannot find out how to "shuffle" this group of cells. Originally I wanted to assign these cells numbers and shuffle the whole box (range) randomly.
So to get around that, I created a 10x10 table of cells with grouped fill colors, then assigned all cells random values with the =RAND() function, then sorted the box based on the random values, copy/pasted a transposed box, resorted, transposed, etc, until I had a completely random box of colors. Now I would like to assign each color it's own value, while keeping the colors exactly where they are. So for example, there are 4 green boxes in my diagram. I'd like to assign all 4 green boxes with a value of 20. There are 8 black boxes in my diagram. I'd like to assign each black box with a value of 10.
See attached for my diagram. It should be noted that this is a miniature example version of my real project, which is many thousands of cells and would be virtually impossible to do manually.
Also, I had posted this same question in this thread as a reply, but was told that is not allowed (my apologies for that). Here is the relevant thread for reference.
http://www.excelforum.com/excel-gene...ell-color.html
Thanks very much!
Bookmarks