Testing for existence of a formula

B

Bob

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
 
B

Bob

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
 
B

Bob

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
 
T

Teethless mama

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