Requirement 1: In my real application the cells color should change on clicking the cell, the application is each cell value when clicked will show a route, a path to the user as a guide so not it is not necessary that i have the same colors shown statically for a pattern. I could as presented just change the color of all the cells, to unique to show a relationship. However, the relationship changes based on the cell i click, (For each cell i will select and use your formulae/macro). So it is relationship is defined by my selection.
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. 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). On 5/22/10, startingexcel <[email protected]> wrote: > Hi Gurus, > > looking for help in creating a excel with cells in relationship which > is when i click on any the cells which are linked, the color of all > the realted cells should change. > > and list of all the related cells created ( there is no pattern so, i > would manually create one) should be displayed. > > PS: can attach the file, a dummy example created but i do not find the > attach option. > > thanks in advance > - Nandu -- -- Anand -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
