Function for determining if cell content is formula vs value

  • Thread starter Thread starter Occupant
  • Start date Start date
O

Occupant

Is there a way to determine if a cell contains a formula
or a value? The ISxxx( ) and CELL( ) functions don't
appear to be able to do this.

I want to use conditional formatting to show if a cell
with a formula has been changed to a value and so far
I'm completely stumped.

Oscar
 
Perfect!
This is the first time I've used, or even heard of, UDF's.
Your response has enabled me to get one running which
does exactly what I wanted.
Thank you very much.

Oscar
 
Back
Top