Testing for existence of a formula
 

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

Testing for existence of a formula
 

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

--
Brevity is the soul of wit.


"Bob" wrote:

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

Testing for existence of a formula
 

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


"Dave F" wrote:

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

--
Brevity is the soul of wit.


"Bob" wrote:

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

Testing for existence of a formula
 

See this:

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

Biff

"Bob" wrote in message
...
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


"Dave F" wrote:

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

--
Brevity is the soul of wit.


"Bob" wrote:

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

Testing for existence of a formula
 

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


"Biff" wrote:

See this:

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

Biff

"Bob" wrote in message
...
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


"Dave F" wrote:

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

--
Brevity is the soul of wit.


"Bob" wrote:

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

Testing for existence of a formula
 

Try this:
Highlight your data range then in the menu select
EditGo ToSpecialFormulaselect any format colorthen hit enter

"Bob" wrote:

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