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.
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
