=Isformula ???? Does something like this exist
Posted by Travis on September 28, 2001 12:48 PM
Anybody know a formula that evaluates whether a cell has a formula in it?
For example
=isformula(A1)
if A1 has a formual in it then the "isformula" would return True, else False
Or something like that...
Thanks
Posted by Aladin Akyurek on September 28, 2001 1:43 PM
Travis --
You need a user-defined function for this. The following code will do what you want.
Function IsFormula(c)
IsFormula = c.HasFormula
End Function
A piece code that one comes across very often
Aladin
============
Posted by . on September 28, 2001 3:54 PM
What's this? Aladin's using the dreaded VBA !
Posted by Travis on September 28, 2001 9:08 PM
Re: =Isformula ...Thanks
That was easy...thanks
Posted by Ian on September 28, 2001 9:28 PM
If you want to highlight cells containing formulas (without reverting to VBA !) ......
Define a name (let's say, HasFormula) and type in the refers to box =GET.CELL(48,INDIRECT("rc",FALSE))
Select the cells you want highlighted if they contain a formula. Go to conditional formatting, put in the FormulaIs box =HasFormula, and set your format.
