Testing for existence of a formula

[Guest]

Is there a way to test if a given cell contains a formula? I have tried
using the LEFT, LEN, TYPE, and CELL functions, but to no avail.
Any help would be greatly appreciated.
Thanks,
Bob

 

[Guest]

Well, there's a UDF, getformula() that you can create. Here's some info,
along with instructions about how to make it work:
http://www.mvps.org/dmcritchie/excel/formula.htm Post back here if you have
questions.

Dave

 

[Guest]

Dave,
Thanks for your help. I was hoping to utilize one of Excel's built-in
functions without resorting to a UDF. But if that's the only way to do it,
then I guess I'll have to use the UDF.
Thanks again,
Bob

 

[Biff]

See this:

http://j-walk.com/ss/excel/usertips/tip045.htm

Biff

 

[Guest]

Biff,
Interesting solution, although not as "simple" as I was hoping for, which
was an in-cell, built-in function (and without the use of conditional
formatting). There are only a few cells (versus the entire worksheet) that I
want to test for the existence of a formula.
Nevertheless, thanks for the suggestion.
Bob

 

[Guest]

Try this:
Highlight your data range then in the menu select
Edit>Go To>Special>Formula>select any format color>then hit enter