View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KMH
 
Posts: n/a
Default How can I determine if a cell has a value (#) or a formula (X*Y)?

I would like to have the cell font color change (conditional format) to
denote whether there is a value (a simple number) or a formula in the cell
(X*Y) where X*Y could be a reference to another cell or just a typed in =2*3.

This will help users know when they should use some caution in changing an
input when there is a formula inside the cell or just simply over ride when
there is a simple dumb input.

Thanks for your help.