On 2/4/07, Ennio-Sr <[EMAIL PROTECTED]> wrote:
Hi Mark,* Mark Knecht <[EMAIL PROTECTED]> [030207, 17:20]: [...] > Thanks for the responses. Sorry but I see I wasn't clear enough. > Let me write a bit more. > > I'm not looking for mouse hot spots, although that would be very > cool. In my case I have completely selected the cell either using my > keyboard or the mouse. At this point the 'Name Box' in the upper left > shows the cell's address saying 'B1' or 'C5'. What I need is that as I > move the selected cell, using the keyboard arrow keys for instance, I > will go from B1 to B2 to C3 to C4 to C5. As I make each of those steps > I need a specific cell in my spreadsheet to show me the value in the > cell I'm at as I pass through them. > Isn't this value (in case it is a value and not a formula) already shown in the cell next to what you call 'Name Box'? (on the bar appearing just before the SS) > Here's the setup. I have a list of 100 stocks which gets updated > each week. In my spreadsheet I have built an array of each week's list > residing in a column with increasing weeks going to the right. For 26 > weeks I have 26 columns of 100 stocks. Elsewhere in my spreadsheet I > have a cell where I can type into it an arbitrary stock symbol. Using > conditional formatting the spreadsheet then highlights every > occurrence of that stock's symbol in the array. This is great and > helps me see how each stock has been moving in the list as the weeks > progress. However, it's a bit difficult and slow since I have to > always go back to that one cell to enter a stock symbol and then have > to scroll up/down/left/right to see the whole array as this array > continues to grow to the right week after week. > > What I would like to do is to select any cell in the main array of > stocks and have the contents of that cell put in my main selection > cell, which will then cause the main array conditional formatting to > show me all the other cells with the same symbol. > > Maybe you can think of an easier way to do this? > I'm not sure to have fully understood what you are attempting to do; anyway, just in case I did get it right, you could try this sort of workaround: 1. in the conditional formatting, set the 'equal to' condition to cell $A$1 2. reserve the first raw in the ssheet to contain such chain, starting from cella A1: =B1, =C1, =D1 (so cell Xn-1 would be =Xn) Supposing you're looking at the 26th week and want to change your stock symbol, you would only have to put a new symbol in in the top raw of that column: this will get copied to all cells of the raw, including $A$1 which triggers the conditional formatting. HTH Regards, Ennio.
Hi Ennio, Thanks for the response. What you are suggesting is possible (I think!) but it still involves going away from the cell I am looking at to type a value into one of these top cells. Imagine that you have a large array. It's 1000 rows by 1000 columns. Maybe you are visually looking somewhere in the middle of this large array. Now, you want to know all locations in the large array that have the value you are currently looking at. Let's say I want to see every instance on INTC, so now I have to scroll up, reposition my cursor, type INTC, and then go back down to where I was in the array to see where else INTC appears. This is what I already do. What I would *like* to do, if it is possible, would be to see INTC in the table visually and just click my mouse there selecting that cell. Having selected that cell this function I'm asking about would know the contents of the cell and then my same conditional formatting would then show me all the locations in the array that have the symbol INTC. This way I never navigate away from the location I'm looking at. Click on any location and all other locations with the same symbol light up with a green background. At least that's what I see in my head. It all works already except for the part where I click on a cell. Thanks again for the response. I hope that maybe someone will come up with a solution over the next few days as it would save me scrolling around quite a bit. Cheers, Mark --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
