View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bradleyGSK bradleyGSK is offline
external usenet poster
 
Posts: 1
Default move to cells automatically by using tab button

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