Hi Guru FoxGuy,
Thank you for the time Guru.
Please find the answers in Royal Blue.
When you double click an empty cell, you want to have all lists colored with the border you chose for each list. Is that right?
-- Yes
When you double click the master cell of a list, you want all other lists to be white, except the one you double clicked. Is that right?
-- Any color option if possible to provide like grey etc would be treat to see.
1) When the file opens, all the groups are colored except 1 (B13:E13 have white cell color and no borders).
--- This is because colors are not assigned so Expected behaviour
My Action - (Results)
2) Double Click B13 - (B13:E13 are colored. B13 has thick border. All other cells - no changes)[/SIZE]
-- Not Expected Behaviour; All other cells should go be to a "if possible default color grey or something to show they are disabled, if difficult, white is fine" retaining the borders formatting
3) Click F2 - (Nothing happens)[/SIZE]
-- Single click so expected Behavior
4) Double Click F2 - (F2, B4:H4, D8:H8, F11, H11 all change to white cell color, and borders stay the same. All other cells - no changes)[/SIZE]
-- Not expected; Double click on F2 will show F2 cell relationship as defined. If already selected, no change. Here it is assumed user double clicks on cell he wants to see the relationship.Rest every cell should be to default color "grey or color of choice" if difficult then white is fine, retaining the border fomatting.
5) Double Click F2 again - (F2, B4:H4, D8:H8, F11, H11 all get colored.)[/SIZE]
-- If already selected to display relation then No change, If F2 is double clicked while other cell is ex B13 cell relation is on, then show F2 relationship.
Will all the cells in 1 group always have the same border style? Or will the master cell have a different border than the rest of the group?[/SIZE]
-- Master cell, i assume is the cell double clicked, to let user know which cell relation they are seeing should be Thick Border, with bigger font.
Will you manually put the border on the cells in [How Cells Are Linked]!C5:C19? Or do you want to manually put the borders on [Cell Links]!cells and the program saves them (that way each cell can have a different border if you want)?[/SIZE]
-- Not sure if there can be easier way, i was manually putting the formatting in the cell saved coloumn along with color and i am manually adding the cell numbers. If there is easier way that would be great but may be step by step..
Once again Thanking you a ton
Nandu
Bookmarks