View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default distinguishing formula cells

I have a column where most cells are based on a formula; but from time
to time I would override selected cells with a plain number.

Is there a way to automatically show (say with a shading) which cells
in a column are based on formulas and which cells are directly entered
numbers (the ability to do either one is sufficient, but I'd like to
know how to do both) ?

Thanks in advance - its amazing how much help one gets in this ng.