I link each cell manually and the when clicked on cell it should be colored.
How do you link cells?

Quote Originally Posted by learning View Post
Note 1: C4 when clicked may show change of colors to C4, D6, E10. and list them in the
result cell ..
Example 1:
User Action: Click C4,
Program does:
1. Change colors(selected by user, should not prompt, predefined) of
random cells selected by user earlier to create a group say ( C4, D6, E10)
2. List those cell values in the result box.
In Example above, what happens if the user clicks D6? would it still show C4, D6, E10?
In Example below, if user clicks D6 it would show D6, D8, C8, F8.
Does that mean that D6 can belong to 2 groups?
How can the program know which group to show?
But when i click on D6, the relationship is not same, it could be
User Action: Click D6, Program shows up change of color ( user selected) (D6, D8, C8, F8)...
Requirement 2: It is just a visual representation, of listing all the values of the cells, related (as i randomly selected), in the cell or list of cells or drop down box ( any thing is fine).
2. List those cell values in the result box.
Where is the result box?

Also, I think using a single click to trigger these actions might cause problems later. I believe that using double clicks would be better. It is a REALLY easy change if you agree.