Function for determining if cell content is formula vs value

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
 
O

Occupant

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

David McRitchie said:
Hi Oscar,
You would need to install a UDF.

Function HasFormula(cell)
HasFormula = cell.HasFormula
End Function

=HasFormula(B2)
=personal.xls!HasFormula(B2)

to install and use a User Defined Function (UDF)
see tp://www.mvps.org/dmcritchie/excel/getstarted.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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
Click to expand...
Click to expand...
 
Top