View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aprilm aprilm is offline
external usenet poster
 
Posts: 1
Default manual numbers entered in formula

Is there a function within Excel, that allows you to search for any relevant
cells that have a hardcoded amount within a formula, ie. adding, subtracting,
dividing or multiplying a harcoded number.
eg. cell B2 + cell B3 + 5 and then identifying that cell because it has a +5
(however, being able to identify any hardcoded number anywhere from
-9,999,999,999 to 9,999,999,999)