+ 0 Votes Trace ben.rattigan 6 years ago I am not entirely sure what your asking here or expecting. You probably need to use the Trace Precedents or Trace Dependents option.When you edit a cells formula it will highlight "connected" cells, what version of Excel are you using. + 0 Votes Excel version raineyamcdonald 6 years ago I'm using Excel 2003. I believe your question may answer mine. I need to "connect" the cells - possibly create "dependents". I simply wish to have groups of cells linked together by some method. If I have "fruit" in a1 and someone clicks on fruit (or types in fruit in a text box - but I'm keeping it simple here), then if b4 contains "Apple" and c8 contains "Grapefruit" and f99 contains "Orange" I want a1,b4,c8, and f99 to respond - I may copy the data to a list or some other method - I'm not worried about that now - also, if f99 is selected I still want the same 4 highlighted.This will have many separate dependencies - for example, b5 may be "veggies" and x14 may be "food" in which case any cells tagged in some way (connected in some way) would be included in the response.