Prev: Can I Use a Count Function for Text?
Next: how to unshared
From: bradleyGSK on 22 May 2010 18:36
good day
firstlt i ave a sheet with 12374 cells which i have condition formated to
change cell colour for value between a certain number.these cells are
scattered across the page .how can i jump to them automatically.for example
ii should press tab it must go to the next cell containing format and if i
press tab again it must go to next cell it registers that have a codion
format and so on.instead of me scrolling looking for cell colour changes
thanks for the help
From: L. Howard Kittle on 22 May 2010 18:53
One way is to name the cell range. Might be a large task given the 12k plus
cells.

Start with the second cell of the sequence and while holding down the Ctrl
key select each cell until you are back to the FIRST cell. Click in the
name box ad enter a suitable name, then Enter.

So now when you want to cruise through those cells, you click on the name
box arrow and select the named range and all those cells will be
highlighted. Now Tab away. If you know you have a long way to go to get to
a certain cell you can hold the TAB key down and you will zip pretty fast
through the cells.

It may be you will want to have several named ranges depending on certain
data or what ever.

HTH
Regards,
Howard

"bradleyGSK" <bradleyGSK(a)discussions.microsoft.com> wrote in message
news:37310D5C-66B5-47CC-A701-87190E0FD2AB(a)microsoft.com...
> good day
> firstlt i ave a sheet with 12374 cells which i have condition formated to
> change cell colour for value between a certain number.these cells are
> scattered across the page .how can i jump to them automatically.for
> example
> ii should press tab it must go to the next cell containing format and if i
> press tab again it must go to next cell it registers that have a codion
> format and so on.instead of me scrolling looking for cell colour changes
> thanks for the help


 | 
Pages: 1
Prev: Can I Use a Count Function for Text?
Next: how to unshared